| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | "Postgres SQL list" <pgsql-sql(at)postgresql(dot)org>, "Attila Kevei" <attila(dot)kevei(at)mail(dot)goodwill(dot)hu> |
| Subject: | Re: select returns no line |
| Date: | 2001-01-23 16:01:11 |
| Message-ID: | 007701c08555$b6102680$1001a8c0@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
----- Original Message -----
From: "Attila Kevei" <attila(dot)kevei(at)mail(dot)goodwill(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-01-23 16:05:56 | Re: monster query, how to make it smaller |
| Previous Message | clayton cottingham | 2001-01-23 15:50:02 | [notion]: a possible language addition: XQL |