On Tue, 15 May 2001, Gavin Sherry wrote:
> Hi all,
>
> Can't for the life of me figure out the problem here:
>
> CREATE TABLE "b" (
> "id" bigint,
> "string" text
> );
>
> CREATE INDEX "b_pkey" on "b" using btree ( "id" "int8_ops" );
Because of a problem with the typing of i
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
-
