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)). ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
