On Sat, 2006-10-07 at 11:57 -0400, Tom Lane wrote: > Rafal Pietrak <rafal@xxxxxxxxxxxxxxxxxx> 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, I understand, you mean 'internal representation'. Since it's quite obvious, that 'external representation' can be '+/-infinity', just like it's the case with the timestamp. > 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. I see. Provided the internal representation must change to get there, some immediate measure (like faulting the statement) might be a good idea ideed. -- -R
