On Tue, Apr 19, 2005 at 01:27:09PM -0700, Zuoxin.Wang@xxxxxx 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/
