Re: Query planner isn't using my indices

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Shaun Thomas <sthomas(at)townnews(dot)com>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query planner isn't using my indices
Date: 2002-01-09 21:24:14
Message-ID: 20020109132322.X73577-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Wed, 9 Jan 2002, Shaun Thomas wrote:

> On Tue, 8 Jan 2002, Stephan Szabo wrote:
>
> > See past discussions, you'll need to either explicitly cast the
> > constant to bigint or quote it, because otherwise it prematurely
> > casts the constant into an int4.
>
> Can anyone explain this to me? Anyone at all? I mean, what logical
> reason is there to leave the database so crippled?

Perhaps you should see the past discussions (particularly on hackers)
of this topic.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cindy 2002-01-09 22:46:38 auto start up at boot time
Previous Message Tom Lane 2002-01-09 21:03:29 Re: Question regarding VACUUM ANALYZE ERROR . . .