Re:

On Tue, Apr 19, 2005 at 01:27:09PM -0700, Zuoxin.Wang@kp.org wrote:
>
> test=# select  first_name, last_name, used, birthday from patient;
>  first_name | last_name | used |  birthday
> ------------+-----------+------+------------
>    | 1960-02-01DI       | N
>    | 1960-02-01DI       | N
> (2 rows)

I'd guess that the "used" columns contain carriage returns.  What
do you see if you run the following query?

SELECT replace(used, '\r', '\\r'), length(used) FROM patient;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/