Re: Not using index on VERY simple query - Mailing list pgsql-general

Jeffrey W. Baker writes:

> On Mon, 8 Oct 2001, Jeffrey W. Baker wrote:
>
> > Unfortunately for me, pg chooses NOT to EVER use the indexes for id and
> > object:
>
> Crass reply to self:
>
> Looks like quoting the bigint values makes pg use the index.  Definitely
> not intuitive.  Does this work without the quotes on actual 64-bit
> platforms?

No, this is a deficiency in PostgreSQL.  See the archives.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter