[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.
Horst