X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1015A53993 for ; Tue, 19 Apr 2005 17:48:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15964-10 for ; Tue, 19 Apr 2005 20:48:03 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 9D0A9539B3 for ; Tue, 19 Apr 2005 17:48:02 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 19 Apr 2005 15:48:01 -0500 Subject: Re: From: Scott Marlowe To: Zuoxin.Wang@kp.org Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1113943681.20921.562.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 19 Apr 2005 15:48:01 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/276 X-Sequence-Number: 17289 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, Zuoxin.Wang@kp.org 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