[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] re: openemeds with postgres

From: Horst Herb
Subject: Re: [Gnumed-devel] re: openemeds with postgres
Date: Mon, 22 Dec 2003 12:23:45 +1100
User-agent: KMail/1.5.93

On Mon, 22 Dec 2003 12:07, syan tan wrote:
> I'm not sure if it is just with postgres, but there is a data validation
> problem when inserting or extracting patients.
> The trait names aren't trimmed of trailing spaces, and this makes the
> retrieval within AbstractIdentity fail.
> The behaviour is that a pids server which is kept running between client
> restarts will return any stored  patients

It depends on what data type you use on Postgres.
char(n) fields will always fill up unused space with spaces, whereas the data 
type "text" will deliver "trimmed" strings.

Alternatively, you could use the "trim" functions PostgreSQL has built into 
it's procedureal languages.

As an aside, I am enthused by your work on the OpenEMED PIDS, since this is 
work I was intending to take on as well. I feel we will soon have great need 
for it in Australia for a variety of reasons.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]