It looks like you have some non-printing characters (like ansi positioning characters or something) in your data.
On Tue, 2005-04-19 at 15:27, [EMAIL PROTECTED] wrote: > Hi all, > Does any one know why I have following inconsistant results from > PostgreSQL? > Thanks in advance. > > test=# select birthday from patient; > birthday > ------------ > 1960-02-01 > 1960-02-01 > (2 rows) > > test=# select used from patient; > used > ------ > N > N > (2 rows) > > > 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) > > test=# select first_name, last_name, birthday, used from patient; > first_name | last_name | birthday | used > ------------+-----------+------------+------ > AAAAAA | TDI | 1960-02-01 | N > AAAAAB | TDI | 1960-02-01 | N > (2 rows) > > test=# > > Jason ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
