On Mon, May 17, 2010 at 1:17 PM, Ken Winter
<ken@sunward.org> wrote:
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”.
I don't have version 8.3 with me right now but I just gave it a try with 8.4 and it gave me the expected output:
postgres=# CREATE TABLE _test
postgres-# (
postgres(# timestampx timestamp without time zone DEFAULT 'infinity'::timestamp without time zone,
postgres(# datex date DEFAULT 'infinity'::timestamp without time zone
postgres(# );
CREATE TABLE
postgres=# INSERT INTO _test DEFAULT VALUES;
INSERT 0 1
postgres=# SELECT * FROM _test;
timestampx | datex
------------+----------
infinity | infinity
(1 row)
postgres=# select version();
version
--------------------------------------------------------------------------------------------------
PostgreSQL 8.4.3 on i686-pc-linux-gnu, compiled by GCC gcc (Ubuntu 4.4.1-4ubuntu9) 4.4.1, 32-bit
(1 row)
--
Shoaib Mir
http://shoaibmir.wordpress.com/
