"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.
regards, tom lane