|
The documentation at http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems to say that the special value ‘infinity’ (“later than all other time stamps”) should work for an date-time column, and the type “date” is listed as among the date-time data types.
But I can’t get ‘infinity’ to work for columns of type “date”.
Here’s a test case:
CREATE TABLE _test ( timestampx timestamp without time zone DEFAULT 'infinity'::timestamp without time zone, datex date DEFAULT 'infinity'::timestamp without time zone ) );
INSERT INTO _test DEFAULT VALUES;
SELECT * FROM _test;
This returns (as viewed through pgAdmin III):
timestampx datex ----------- ----- infinity
When I tried to declared the “datex” column like this:
datex date DEFAULT 'infinity'::date
I got this:
ERROR: invalid input syntax for type date: "infinity"
Is there any way to get ‘infinity’ to work for a “date” column?
Or any other way to get the equivalent functionality in a date column?
~ TIA ~ Ken |
