Re: PostgreSQL doesn't use indexes even is enable_seqscan = off - Mailing list pgsql-general

On Sun, 07 Jul 2002 10:48:51 +0200, Hans-Juergen Schoenig
<hs@cybertec.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