Re: BUG: bigint and indexes ?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Victor Krasinsky <victor(at)psoft(dot)lviv(dot)ua>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG: bigint and indexes ?
Date: 2002-03-04 21:00:32
Message-ID: 20020304125950.R80308-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Fri, 1 Mar 2002, Victor Krasinsky wrote:

> Is it a known bug if optimizer, that Postgres can't use indexes created on a int8 (bigint) ?
> This problem exists in 7.1.3 and even in 7.2.

You need to explicitly cast the constant that you're comparing to
bigint (1::bigint or CAST(1 as bigint)).

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-03-04 21:54:17 Re: Bug #607: to_date() function bug
Previous Message pgsql-bugs 2002-03-04 19:21:10 Bug #607: to_date() function bug