"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
