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 B726E52A57 for ; Tue, 19 Apr 2005 17:35:53 -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 10120-09 for ; Tue, 19 Apr 2005 20:35:45 +0000 (GMT) Received: from mail.kp.org (ktazp5001.kp.org [162.119.241.43]) by svr1.postgresql.org (Postfix) with ESMTP id B5D94539BB for ; Tue, 19 Apr 2005 17:35:43 -0300 (ADT) Received: from ktazp598.kp.org ([172.21.128.151]) by mail.kp.org with ESMTP id j3JKPEjg013483 for ; Tue, 19 Apr 2005 16:27:24 -0400 (EDT) Received: from cscrdngat001.crdc.KP.ORG by ktazp598 with ESMTP for pgsql-admin@postgresql.org; Tue, 19 Apr 2005 13:27:11 -0700 To: pgsql-admin@postgresql.org Subject: MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-Id: From: Zuoxin.Wang@kp.org Date: Tue, 19 Apr 2005 13:27:09 -0700 X-MIMETrack: Serialize by Router on CRDC-GWY01/GSVR/KAIPERM(Release 5.0.11 |July 24, 2002) at 04/19/2005 01:29:11 PM, Serialize complete at 04/19/2005 01:29:11 PM Content-Type: multipart/alternative; boundary="=_alternative 0070599D88256FE8_=" X-KP: PPSAV - [172.21.128.151] - 2005-04-19 - 16:27:26 X-Proofpoint-Spam-Score: : 0 X-Spam-Details: rule=notspam score=0 mlx=-1 adultscore=0 adjust=0 version=2.1.0-05041800 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.257 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_60_70, HTML_MESSAGE, MISSING_SUBJECT, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200504/274 X-Sequence-Number: 17287 This is a multipart message in MIME format. --=_alternative 0070599D88256FE8_= Content-Type: text/plain; charset="us-ascii" 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 --=_alternative 0070599D88256FE8_= Content-Type: text/html; charset="us-ascii"
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
--=_alternative 0070599D88256FE8_=--