Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group