gr-test=> \d invitecodes
Table "public.invitecodes"
Column | Type | Modifiers
------------+--------- +-----------------------------------------------------------------
invite | integer | not null default nextval('public.invitecodes_invite_seq'::text)
sponsor | bigint | not null
generated | integer | not null default ((now())::abstime)::integer
expires | integer | not null
acceptedby | bigint |
acceptedon | integer |
expiredon | integer |
gr-test=> select expires from invitecodes; expires ------------ 1111611373 1111551093 1112139900 1112169368 (4 rows)
gr-test=> select expires from invitecodes where expires < ((now())::abstime)::int4;
ERROR: unsupported type: 23
gr-test=> select expires from invitecodes where expires > 1; expires ------------ 1111611373 1111551093 1112139900 1112169368 (4 rows)
gr-test=> select expires from invitecodes where 1 < ((now())::abstime)::int4;
expires
------------
1111611373
1111551093
1112139900
1112169368
(4 rows)
I haven't a clue how to go about debugging this. Any pointers?
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org