[HACKERS] infinity and DATE type
Is there a reason why the DATE type does not support infinity something like the DATE type? wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] infinity and DATE type
Warren Turkal [EMAIL PROTECTED] writes: Is there a reason why the DATE type does not support infinity Nobody got round to it. I believe it's listed in the TODO file ... regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] infinity and DATE type
On Thursday 22 February 2007 00:20, Tom Lane wrote: Nobody got round to it. I believe it's listed in the TODO file ... It's not at [1]. Should someone add it to the TODO? [1]http://www.postgresql.org/docs/faqs.TODO.html wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] infinity and DATE type
Warren Turkal [EMAIL PROTECTED] writes: On Thursday 22 February 2007 00:20, Tom Lane wrote: Nobody got round to it. I believe it's listed in the TODO file ... It's not at [1]. Should someone add it to the TODO? I see * Dates and Times o Allow infinite dates and intervals just like infinite timestamps regards, tom lane ---(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
Re: [HACKERS] infinity and DATE type
On Thu, 22 Feb 2007, Warren Turkal wrote: On Thursday 22 February 2007 00:20, Tom Lane wrote: Nobody got round to it. I believe it's listed in the TODO file ... It's not at [1]. Should someone add it to the TODO? [1]http://www.postgresql.org/docs/faqs.TODO.html Yes it is. Allow infinite dates and intervals just like infinite timestamps Gavin ---(end of broadcast)--- TIP 6: explain analyze is your friend