"Joshua D. Drake" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster