Tom Lane wrote:
> Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)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