Re: 'Infinity' in date columns?

On Mon, May 17, 2010 at 1:17 PM, Ken Winter <ken(at)sunward(dot)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/