Re: optimiser problem

Gavin Sherry <swm@linuxworld.com.au> writes:
> CREATE TABLE "b" (
>         "id" bigint,
>         "string" text
> );

> SELECT * FROM b WHERE id=1;

Try "WHERE id = 1::bigint".

(Hey Bruce, is there anything about this in the FAQ?)
        regards, tom lane