Re: Bug #580: Optimizer uses seq scan only - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Bug #580: Optimizer uses seq scan only
Date
Msg-id 20020211154206.C84923-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Bug #580: Optimizer uses seq scan only  (pgsql-bugs@postgresql.org)
List pgsql-bugs
On Mon, 11 Feb 2002 pgsql-bugs@postgresql.org wrote:

> Janko Richter (j.richter@wallstreet-develop.de) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> Optimizer uses seq scan only

You'll need to cast the value you're comparing with to int8
(12345::int8 or CAST(12345 as int8) should work).

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #580: Optimizer uses seq scan only
Next
From: Tom Lane
Date:
Subject: Re: Bug #580: Optimizer uses seq scan only