Re: unsupported types in 8.0.1 - Mailing list pgsql-general

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@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