pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: patrick.jacquot@anpe.fr
To: Postgres SQL list <pgsql-sql@postgresql.org>
Subject: Re: select returns no line
Date: Tue, 23 Jan 2001 16:21:15 +0100
Message-ID: <3A6DA16A.67018D22@anpe.fr> (raw)
References: <980253179.3a6d79fb29871@www.goodwill.hu>

Attila Kevei wrote:

> 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

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




view thread (10+ messages)  latest in thread

Message-ID: <3A6DA16A.67018D22@anpe.fr>
Permalink:  ../3A6DA16A.67018D22@anpe.fr/
Also on:    postgresql.org/message-id/3A6DA16A.67018D22@anpe.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: patrick.jacquot@anpe.fr
  Subject: Re: select returns no line
  In-Reply-To: <3A6DA16A.67018D22@anpe.fr>
  References: <980253179.3a6d79fb29871@www.goodwill.hu> <3A6DA16A.67018D22@anpe.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox