Re: Query planner isn't using my indices

From: "Alaric B(dot) Snell" <abs(at)frontwire(dot)com>
To: Jason Earl <jason(dot)earl(at)simplot(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query planner isn't using my indices
Date: 2002-01-09 10:51:48
Message-ID: Pine.LNX.4.43.0201091051050.30597-100000@calvin.frontwire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)frontwire(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman Gavrilov 2002-01-09 11:31:30 Monitoring database
Previous Message Nandu Garg 2002-01-09 10:29:21 Problem in starting postgresql