Tilman Baumann <[EMAIL PROTECTED]> writes: > I see there is a isfinite(interval) function.
Looks like it's just a stub :-( Datum interval_finite(PG_FUNCTION_ARGS) { PG_RETURN_BOOL(true); } Evidently someone planned for infinite intervals a long time ago, but never got round to it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match