Re: Bug #580: Optimizer uses seq scan only - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> CREATE TABLE test (
>   testid  int8 not null default 0,

> janko=# EXPLAIN SELECT * FROM test WHERE testid = 12345;

Try 12345::int8.  Yes, we know it's a pain in the neck.

            regards, tom lane