Tom Lane wrote:
Rafal Pietrak <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
