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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])