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/