Re: 'Infinity' in date columns?

From: Lew <noone(at)lewscanon(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 'Infinity' in date columns?
Date: 2010-05-17 12:04:01
Message-ID: hsrbb6$1o2$1@news.albasani.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-05-17 12:28:53 Re: pg_dumpall custom format?
Previous Message seiliki 2010-05-17 09:53:25 Getting reference key elements in right orders