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 BCA9153366 for ; Tue, 19 Apr 2005 18:09:47 -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 17913-06 for ; Tue, 19 Apr 2005 21:09:46 +0000 (GMT) Received: from mail.kp.org (ktazp5001.kp.org [162.119.241.43]) by svr1.postgresql.org (Postfix) with ESMTP id EA33053345 for ; Tue, 19 Apr 2005 18:09:45 -0300 (ADT) Received: from ktazp598.kp.org ([172.21.128.151]) by mail.kp.org with ESMTP id j3JKpqlg020591 for ; Tue, 19 Apr 2005 17:00:15 -0400 (EDT) Received: from cscrdngat001.crdc.KP.ORG by ktazp598 with ESMTP for pgsql-admin@postgresql.org; Tue, 19 Apr 2005 14:00:00 -0700 To: pgsql-admin@postgresql.org Subject: Missing value from PostgreSQL query? 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:59:57 -0700 X-MIMETrack: Serialize by Router on CRDC-GWY01/GSVR/KAIPERM(Release 5.0.11 |July 24, 2002) at 04/19/2005 02:01:59 PM, Serialize complete at 04/19/2005 02:01:59 PM Content-Type: multipart/alternative; boundary="=_alternative 00735A3388256FE8_=" X-KP: PPSAV - [172.21.128.151] - 2005-04-19 - 17:00:16 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=0.574 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_60_70, HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200504/280 X-Sequence-Number: 17293 This is a multipart message in MIME format. --=_alternative 00735A3388256FE8_= Content-Type: text/plain; charset="us-ascii" Hi all, Does any one know why I have following inconsistant results from PostgreSQL under Cygwin? When I switch the select order, or use "select * from patient", some values are missing from returned results. What might be wrong? Thanks in advance. 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) /* worked fine */ est=# 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 used, birthday from patient; used | birthday ------+------------ | 1960-02-01 | 1960-02-01 (2 rows) Jason --=_alternative 00735A3388256FE8_= Content-Type: text/html; charset="us-ascii"
Hi all,
Does any one know why I have following inconsistant results from PostgreSQL under Cygwin?

When I switch the select order, or use "select * from patient", some values are missing from returned results.

What might be wrong?

Thanks in advance.
 

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)
/* worked fine */

est=# 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 used, birthday from patient;
 used |  birthday
------+------------
   | 1960-02-01
   | 1960-02-01
(2 rows)


Jason
--=_alternative 00735A3388256FE8_=--