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

From Ken Winter
Subject Re: 'Infinity' in date columns?
Date
Msg-id E15398033A2F4F608D2BCC60DF47865D@KenIBM
Whole thread Raw
In response to Re: 'Infinity' in date columns?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Tom Lane
...
>
> "Ken Winter" <ken@sunward.org> writes:
> > 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".
>
> You seem to be carefully reading around the middle column in Table 8-13,
> which specifically shows that infinity doesn't work for type date.

Oh, duh, right you are...

> Now, if you were to update to Postgres 8.4, it *would* work.

I'll see if I can get my host to do that.

~ Thanks
~ Ken




pgsql-general by date:

Previous
From: Justin Graf
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Next
From: Selena Deckelmann
Date:
Subject: Re: Lightning Talks for PgCon! Submit yours today.