Received: from jennifer.emc.com.ph ([203.167.64.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAOB46A32657 for ; Fri, 24 Nov 2000 06:04:07 -0500 (EST) (envelope-from pgsql-sql@fc.emc.com.ph) Received: from fc.emc.com.ph (unknown [203.167.64.16]) by jennifer.emc.com.ph (Postfix) with ESMTP id E9FC4D7C5 for ; Fri, 24 Nov 2000 19:02:37 +0800 (PST) Message-id: Date: Fri, 24 Nov 2000 17:49:06 +0800 Subject: 7.0.3 BUG To: pgsql-sql@postgresql.org From: "pgsql-sql" MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200011/218 X-Sequence-Number: 249 SELECT is returning bogus data. migrate=# select version(); version --------------------------------------------------------------- PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3 (1 row) migrate=# select userid from users where userid = 'reynan@yahoo.com'; userid --------------------- reynan@yahoo.com admin (2 rows) migrate=# \d users Table "users" Attribute | Type | Modifier ------------------+--------------+-------------------------------------------------------- userrefkey | integer | not null default nextval('users_userrefkey_seq'::text) userid | varchar(128) | not null password1 | char(20) | not null password2 | char(50) | type | char(10) | not null partneremail | varchar(128) | adminlastname | char(40) | not null adminfirstname | char(40) | not null adminaddress1 | char(80) | not null adminaddress2 | char(80) | admincity | char(80) | not null adminstateprov | char(40) | admincountrycode | char(2) | not null adminpostalcode | char(10) | adminphone | char(20) | adminfax | char(20) | checkpayableto | char(80) | not null createdate | timestamp | not null default now() lastaccessdate | timestamp | lastmodifieddate | timestamp | Indices: users_pkey, users_userid_key