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

On Sat, Mar 26, 2005 at 08:25:24AM -0800, Ben wrote:
>
> gr-test=> select expires from invitecodes where expires <
> ((now())::abstime)::int4;
> ERROR:  unsupported type: 23

Hmmm...

CREATE TABLE foo (x integer);
INSERT INTO foo (x) VALUES (1000000000);
INSERT INTO foo (x) VALUES (2000000000);

SELECT x FROM foo WHERE x < now()::abstime::integer;
     x
------------
 1000000000
(1 row)

ANALYZE foo;

SELECT x FROM foo WHERE x < now()::abstime::integer;
ERROR:  unsupported type: 23

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/