Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O4Cc033782 for ; Tue, 23 Jan 2001 23:12:38 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0MGxQ047531 for ; Mon, 22 Jan 2001 11:59:26 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f0MGjs336695 for pgsql-sql@postgresql.org; Mon, 22 Jan 2001 11:45:54 -0500 (EST) (envelope-from news) From: kisix X-Newsgroups: comp.databases.postgresql.sql Subject: select returns no line Date: Mon, 22 Jan 2001 17:47:58 +0100 Organization: goodwill.hu Lines: 68 Message-ID: <3A6C643E.B4596D0A@goodwill.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i586) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200101/306 X-Sequence-Number: 975 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). 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