Re: Bug in predicate indexes?

"Joshua D. Drake" <jd@commandprompt.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.
        regards, tom lane