Re: [HACKERS] optimiser problem

[Tom Lane]

Gavin Sherry <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly