Re: time conversion fuinctions - Mailing list pgsql-general

From brian
Subject Re: time conversion fuinctions
Date
Msg-id 4527CFF4.70601@zijn-digital.com
Whole thread Raw
In response to Re: time conversion fuinctions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Rafal Pietrak <rafal@zorro.isa-geek.com> writes:
>
>>Is this the expected result?
>
>
> timestamp_date() currently returns NULL if the timestamp is infinity.
> Since we don't have any representation for infinity in the date type,
> this is pretty much its only alternative other than throwing an error
> (which might indeed be a saner behavior).  There is a TODO item to
> support +/-infinity in dates, which would be the correct long-term
> solution.
>

"long-term", indeed.

b

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: time conversion fuinctions
Next
From: "Tomi NA"
Date:
Subject: performace review