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 Lane||Date: 2002-03-04 21:54:17|
|Subject: Re: Bug #607: to_date() function bug |
|Previous:||From: pgsql-bugs||Date: 2002-03-04 19:21:10|
|Subject: Bug #607: to_date() function bug|