| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: indexing of INT8 ? |
| Date: | 2001-08-01 05:35:39 |
| Message-ID: | Pine.LNX.4.33.0108010834220.21721-100000@melkinpaasi.cs.Helsinki.FI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 1 Aug 2001, hubert depesz lubaczewski wrote:
> hi
> i just checked a friends database and it seems that INT8 fields are not
> indexable.
> i mean:
> he has a table with several fields. one of this fields is int8 with unique
> index.
> we have aproximately 100000 records in this table, database is vacuumed, but
> the index doesn't seem to work when i do something like
>
> explain select * from table where int8field = xxxx;
>
If the index exists the problem might be that 'xxxx' is not an int8 value.
Try select * from table where int8field = xxxx::int8;.
- Einar Karttunen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tauren Mills | 2001-08-01 06:53:50 | RE: Finding number of current connections |
| Previous Message | Stephan Szabo | 2001-08-01 05:34:01 | Re: indexing of INT8 ? |