Received: from thor.tht.net ([209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NCdD057008 for ; Tue, 23 Jan 2001 07:39:14 -0500 (EST) (envelope-from attila.kevei@goodwill.hu) Received: from mail.goodwill.hu (IDENT:root@ip186.d111.tiszanet.hu [217.65.111.186] (may be forged)) by thor.tht.net (8.9.3/8.9.3) with ESMTP id HAA21562 for ; Tue, 23 Jan 2001 07:37:41 -0500 (EST) (envelope-from attila.kevei@goodwill.hu) Received: (from nobody@localhost) by mail.goodwill.hu (8.11.0/8.8.7) id f0NCWx931693 for pgsql-sql@postgresql.org; Tue, 23 Jan 2001 13:32:59 +0100 X-Authentication-Warning: mail.goodwill.hu: nobody set sender to attila.kevei@goodwill.hu using -f To: Postgres SQL list Subject: select returns no line Message-ID: <980253179.3a6d79fb29871@www.goodwill.hu> Date: Tue, 23 Jan 2001 13:32:59 +0100 (CET) From: Attila Kevei MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Originating-IP: 192.168.1.30 X-Archive-Number: 200101/287 X-Sequence-Number: 956 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@swi.hu -x- attila.kevei@goodwill.hu -x- kisiksz@westel900.net -x