Re: unsupported types in 8.0.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Ben <bench(at)silentmedia(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: unsupported types in 8.0.1
Date: 2005-03-26 19:14:46
Message-ID: 14370.1111864486@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2005-03-26 20:22:51 Re: unsupported types in 8.0.1
Previous Message Michael Fuhr 2005-03-26 17:35:53 Re: unsupported types in 8.0.1