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
