Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NG58071513 for ; Tue, 23 Jan 2001 11:05:08 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id QAA17840; Tue, 23 Jan 2001 16:04:54 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 197392A391; Tue, 23 Jan 2001 16:01:16 +0000 (GMT) Message-ID: <007701c08555$b6102680$1001a8c0@archonet.com> From: "Richard Huxton" To: "Postgres SQL list" , "Attila Kevei" References: <980253179.3a6d79fb29871@www.goodwill.hu> Subject: Re: select returns no line Date: Tue, 23 Jan 2001 16:01:11 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/293 X-Sequence-Number: 962 ----- Original Message ----- From: "Attila Kevei" > 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 Have you tried dropping the index? Could be mangled or a locale problem... - Richard Huxton