Re: PostgreSQL doesn't use indexes even is enable_seqscan = off

On Sun, 07 Jul 2002 10:48:51 +0200, Hans-Juergen Schoenig
<hs(at)cybertec(dot)at> wrote:
>I have a severe problem with PostgreSQL 7.2.1.
>CREATE UNIQUE INDEX idx_one_id ON one(id);
> Column | Type | Modifiers
>--------+---------+-----------
> id | bigint |
>cluster=# SELECT * FROM one WHERE id=300000;

Hans, try
SELECT * FROM one WHERE id='300000';
or
SELECT * FROM one WHERE id=300000::bigint;

HTH.
Servus
Manfred