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.
regards, tom lane