From: | Marc Tardif <admin(at)wtbwts(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | now() returning int4 |
Date: | 2000-01-31 16:59:19 |
Message-ID: | Pine.BSF.4.10.10001311649310.63602-100000@server.b0x.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I have a table containing an integer field defaulting to now(), which I
want to use as the unix timestamp counting the seconds from jan 1 1970.
Problem is when I try to perform queries using now():
db=> CREATE TABLE test (
db-> date int default now()
db-> );
CREATE
db=> SELECT * FROM test WHERE date < now();
ERROR: Unable to identify operator '<' for types 'int4' and 'timestamp'
You will have to retype this query using an explicit cast
db=> SELECT * FROM test WHERE date::timestamp < now();
bis
db=> SELECT * FROM test WHERE date < now()::int4;
bis
Please let me know how I can get this to work properly, I'm using
postgresql 6.5.3.
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2000-01-31 22:28:40 | Re: [SQL] now() returning int4 |
Previous Message | Peter Eisentraut | 2000-01-31 12:21:27 | Re: [SQL] inet/cidr - can this be done? |