Re: [HACKERS] Issues with generate_series using integer boundaries - Mailing list pgsql-general

From Thom Brown
Subject Re: [HACKERS] Issues with generate_series using integer boundaries
Date
Msg-id AANLkTikSRudj6B6yeJ0L+ft+mVGbomkbR-rVzf0RNaVX@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Issues with generate_series using integer boundaries  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
List pgsql-general
On 8 February 2011 09:22, Itagaki Takahiro <itagaki.takahiro@gmail.com> wrote:
> On Mon, Feb 7, 2011 at 20:38, Thom Brown <thom@linux.com> wrote:
>> Yes, of course, int8 functions are separate.  I attach an updated
>> patch, although I still think there's a better way of doing this.
>
> Thanks. Please add the patch to the *current* commitfest
> because it's a bugfix.
> https://commitfest.postgresql.org/action/commitfest_view?id=9
>
> I've not tested the patch yet, but if we could drop the following
> line in the patch, the code could be much cleaner.
>  /* ensure first value in series should exist */
>
>> I'm not sure how this should be handled.  Should there just be a check
>> for either kind of infinity and return an error if that's the case?  I
>
> Maybe so. It also works if we had infinity on timestamp overflow, but
> I've not tested yet.  Anyway, we need similar fix for timestamp versions.

Well, in its current state, I expect it to get rejected, but I guess
at least it gets a better chance of being looked at.  I've added it to
the commitfest now.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

pgsql-general by date:

Previous
From: OTSUKA Kenji
Date:
Subject: about PostgreSQL 9.0.3 RPMs
Next
From: Oleg Bartunov
Date:
Subject: Re: fulltext search and hunspell