Re: 'Infinity' in date columns? - Mailing list pgsql-general

From Lew
Subject Re: 'Infinity' in date columns?
Date
Msg-id hsrbb6$1o2$1@news.albasani.net
Whole thread Raw
In response to Re: 'Infinity' in date columns?  (Shoaib Mir <shoaibmir@gmail.com>)
List pgsql-general
Ken Winter 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”.

Shoaib Mir wrote:
> 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:

As Tom Lane points out, that's a difference between 8.3 and 8.4.

--
Lew

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: pg_dumpall custom format?
Next
From: Catalin BOIE
Date:
Subject: Re: PANIC: corrupted item pointer: 32766