From: | patrick(dot)jacquot(at)anpe(dot)fr |
---|---|
To: | Postgres SQL list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: select returns no line |
Date: | 2001-01-23 15:21:15 |
Message-ID: | 3A6DA16A.67018D22@anpe.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Attila Kevei wrote:
> Hi,
>
> Our database has a SELECT problem using varchar columns in WHERE clause
> (but not in all rows!!!).
> We can fix the whole table (or just the row) as shown below but later it
> seems wrong again (and after the fix the row isn't UPDATEd).
>
> Any idea?
>
> Thanks
> Attila
>
> ********************************************************************************
> Environment:
>
> [PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2]
>
> goodwill=>\d users
> Table = users
> +----------------------------------+----------------------------------+-------+
> | Field | Type | Length|
> +----------------------------------+----------------------------------+-------+
> | user_id | int4 not null default nextval ( | 4 |
> | user_login | varchar() not null | 15 |
> | user_passwd | varchar() not null | 15 |
> | user_exp | timestamp | 4 |
> +----------------------------------+----------------------------------+-------+
> Indices: users_pkey
>
> users_user_login_key
>
> ********************************************************************************
> The problem:
>
> goodwill=>select * from users where user_login='test';
> user_id|user_login|user_passwd|user_exp
> -------+----------+-----------+--------
> (0 rows)
>
> goodwill=> select * from users where user_id=4;
> user_id|user_login|user_passwd |user_exp
> -------+----------+-------------+--------
> 4|test |0PDv7a2EESjZo|
> (1 row)
>
> goodwill=> update users set user_login=user_login where user_id=4;
> UPDATE
> 1
>
> goodwill=>select * from users where user_login='test';
> user_id|user_login|user_passwd |user_exp
> -------+----------+-------------+--------
> 4|test |0PDv7a2EESjZo|
> (1 row)
>
> --
> x- kisix(at)swi(dot)hu -x- attila(dot)kevei(at)goodwill(dot)hu -x- kisiksz(at)westel900(dot)net -x
hello
are you sure the value of the user_id in that line is "test" and not "test "
i.e it has not spurious spaces at the end of it ?
HTH
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | clayton cottingham | 2001-01-23 15:50:02 | [notion]: a possible language addition: XQL |
Previous Message | juerg.rietmann | 2001-01-23 14:42:10 | monster query, how to make it smaller |