From: | "Ken Winter" <ken(at)sunward(dot)org> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'PostgreSQL pg-general List'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 'Infinity' in date columns? |
Date: | 2010-05-17 15:45:11 |
Message-ID: | E15398033A2F4F608D2BCC60DF47865D@KenIBM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Tom Lane
...
>
> "Ken Winter" <ken(at)sunward(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Selena Deckelmann | 2010-05-17 15:53:08 | Re: Lightning Talks for PgCon! Submit yours today. |
Previous Message | Thom Brown | 2010-05-17 15:13:05 | Re: Fwd: Google Alert - postgresql 8.4 |