Received: from odysseus1.dohle.com (odysseus1.dohle.com [194.127.185.21]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NE5g062484 for ; Tue, 23 Jan 2001 09:05:42 -0500 (EST) (envelope-from vpaul@dohle.com) Received: from majestix.dohle.com (majestix.dohle.com [194.127.190.1]) by odysseus1.dohle.com (8.9.3/8.9.3) with SMTP id PAA20637; Tue, 23 Jan 2001 15:03:33 +0100 Received: from wpaul.dohle.com by majestix.dohle.com id aa03422; 23 Jan 101 15:03 CET Message-ID: <3A6D9408.E7D7120A@dohle.com> Date: Tue, 23 Jan 2001 15:24:08 +0100 From: Volker Paul Organization: Dohle Handelsgruppe Systemberatung GmbH X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: Attila Kevei CC: Postgres SQL list Subject: Re: select returns no line References: <980253179.3a6d79fb29871@www.goodwill.hu> <3A6DA16A.67018D22@anpe.fr> <980257292.3a6d8a0cad5aa@www.goodwill.hu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/290 X-Sequence-Number: 959 A space or something like that is also what I was thinking of. I'd suggest to: select * from users, length(user_login) where user_id=4; before and after the update. V.Paul