Re: optimiser problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: optimiser problem
Date: 2001-05-15 05:31:20
Message-ID: 29873.989904680@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gavin Sherry <swm(at)linuxworld(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Max Khon 2001-05-15 05:50:57 Re: 7.2 items
Previous Message Tom Lane 2001-05-15 05:26:33 Re: SCHEMA idea