Michael Fuhr <mike@fuhr.org> writes:
> SELECT x FROM foo WHERE x < now()::abstime::integer;
> ERROR: unsupported type: 23
It looks like examine_variable shouldn't be throwing away the
RelabelType on the now() call ... this code is all new in 8.0
IIRC, which is why you don't see the failure in prior versions
(you also do not get a good estimate ...)
regards, tom lane