Re: Bug #580: Optimizer uses seq scan only

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <j(dot)richter(at)wallstreet-develop(dot)de>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #580: Optimizer uses seq scan only
Date: 2002-02-11 23:43:23
Message-ID: 20020211154206.C84923-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Mon, 11 Feb 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Janko Richter (j(dot)richter(at)wallstreet-develop(dot)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).

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Blossom, Eric 2002-02-12 00:01:15 Initdb Hangs
Previous Message Tom Lane 2002-02-11 23:21:56 Re: Bug #580: Optimizer uses seq scan only