Re: [GENERAL] time conversion fuinctions

2006-10-07 Thread Rafal Pietrak
On Sat, 2006-10-07 at 11:57 -0400, 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, I understand, you mean

Re: [GENERAL] time conversion fuinctions

2006-10-07 Thread brian
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 e

Re: [GENERAL] time conversion fuinctions

2006-10-07 Thread Tom Lane
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 i