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 int constants, you'll need
to explicitly cast your constant into an int8 in order to use the
index (where id=1::int8).
> So, a select on b as follows:
>
> SELECT * FROM b WHERE id=1;