Is there a workaround I could use, or should I stick with 7.4 for now?
On Mar 26, 2005, at 11:14 AM, Tom Lane wrote:
> Michael Fuhr <mike(at)fuhr(dot)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