Re: Query planner isn't using my indices - Mailing list pgsql-general

From Alaric B. Snell
Subject Re: Query planner isn't using my indices
Date
Msg-id Pine.LNX.4.43.0201091051050.30597-100000@calvin.frontwire.com
Whole thread Raw
In response to Re: Query planner isn't using my indices  (Jason Earl <jason.earl@simplot.com>)
List pgsql-general
On 8 Jan 2002, Jason Earl wrote:

> If you cast the 1 to type bigint then PostgreSQL will use the index,
> otherwise it won't.  You can do one of four things:

Ahhh, suddenly it all makes sense!

Thanks, people.

Now I need to figure out how to make JBoss write its queries differently
:-)

ABS

--
Alaric B. Snell, Developer
abs@frontwire.com


pgsql-general by date:

Previous
From: Maarten.Boekhold@reuters.com
Date:
Subject: Re: Need help
Next
From: BELLON Michel
Date:
Subject: Unable to start