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.comadmin
(2 rows)
migrate=# \d users Table "users" Attribute | Type |
Modifier
------------------+--------------+--------------------------------------------------------userrefkey | integer
| not null default
nextval('users_userrefkey_seq'::text)userid | varchar(128) | not nullpassword1 | char(20) | not
nullpassword2 | char(50) |type | char(10) | not nullpartneremail | varchar(128)
|adminlastname | char(40) | not nulladminfirstname | char(40) | not nulladminaddress1 | char(80) |
notnulladminaddress2 | char(80) |admincity | char(80) | not nulladminstateprov | char(40)
|admincountrycode| char(2) | not nulladminpostalcode | char(10) |adminphone | char(20) |adminfax
| char(20) |checkpayableto | char(80) | not nullcreatedate | timestamp | not null default
now()lastaccessdate | timestamp |lastmodifieddate | timestamp |
Indices: users_pkey, users_userid_key
