Re: select returns no line - Mailing list pgsql-sql

----- Original Message -----
From: "Attila Kevei" <attila.kevei@mail.goodwill.hu>


> 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