| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| 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:34:01 |
| Message-ID: | Pine.BSF.4.21.0107312233230.4495-100000@megazone23.bigpanda.com |
| 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;
>
> is it known bug of 7.1.2 or is something wrong with the database?
Sort of the former. You need to explicitly cast the xxxx to int8 in
order for the index to get used.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Einar Karttunen | 2001-08-01 05:35:39 | Re: indexing of INT8 ? |
| Previous Message | matthew wong | 2001-08-01 05:27:46 |