On Fri, Nov 18, 2005 at 09:58:24AM -0500, Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> > It appears that predicate indexes won't uses indexes on int8 columns
> > unless they are casted:
>
> This is a known (although perhaps not well documented) limitation of the
> predicate testing logic. You do not need a cast in the query, though,
> only in the index's WHERE condition.
I'm working on a docs patch for this (attached, but un-tested); is
bigint the only datatype this applies to or are there others?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461