Received: from mail.goodwill.hu (ip186.d111.tiszanet.hu [217.65.111.186] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NDfH060892 for ; Tue, 23 Jan 2001 08:41:46 -0500 (EST) (envelope-from attila.kevei@goodwill.hu) Received: (from nobody@localhost) by mail.goodwill.hu (8.11.0/8.8.7) id f0NDfWf00639 for pgsql-sql@postgresql.org; Tue, 23 Jan 2001 14:41:32 +0100 X-Authentication-Warning: mail.goodwill.hu: nobody set sender to attila.kevei@goodwill.hu using -f To: Postgres SQL list Subject: Re: select returns no line Message-ID: <980257292.3a6d8a0cad5aa@www.goodwill.hu> Date: Tue, 23 Jan 2001 14:41:32 +0100 (CET) From: Attila Kevei References: <980253179.3a6d79fb29871@www.goodwill.hu> <3A6DA16A.67018D22@anpe.fr> In-Reply-To: <3A6DA16A.67018D22@anpe.fr> 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/289 X-Sequence-Number: 958 No, there's no space. The query (point 4. below) after the fix (point 3.) is the _same_ as the first (p.1.). In the first select there's no result but in the last select we get the right result. Attila Quoting patrick.jacquot@anpe.fr: 1. > > goodwill=>select * from users where user_login='test'; > > user_id|user_login|user_passwd|user_exp > > -------+----------+-----------+-------- > > (0 rows) > > 2. > > goodwill=> select * from users where user_id=4; > > user_id|user_login|user_passwd |user_exp > > -------+----------+-------------+-------- > > 4|test |0PDv7a2EESjZo| > > (1 row) > > 3. > > goodwill=> update users set user_login=user_login where user_id=4; > > UPDATE > > 1 > > 4. > > goodwill=>select * from users where user_login='test'; > > user_id|user_login|user_passwd |user_exp > > -------+----------+-------------+-------- > > 4|test |0PDv7a2EESjZo| > > (1 row) > > > > 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 > -- x- kisix@swi.hu -x- attila.kevei@goodwill.hu -x- kisiksz@westel900.net -x