Re: Range Types and extensions - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Range Types and extensions
Date
Msg-id BANLkTimKR_=yaN8vLWocoK5j4FYZenL-zQ@mail.gmail.com
Whole thread Raw
In response to Re: Range Types and extensions  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Range Types and extensions
List pgsql-hackers
2011/6/6 Jeff Davis <pgsql@j-davis.com>:
> On Mon, 2011-06-06 at 06:56 +0200, Pavel Stehule wrote:
>> 2011/6/6 Darren Duncan <darren@darrenduncan.net>:
>> > Jeff Davis wrote:
>> >>
>> >> I'd like to take another look at Range Types and whether part of it
>> >> should be an extension. Some of these issues relate to extensions in
>> >> general, not just range types.
>> >>
>> >> First of all, what are the advantages to being in core?
>>
>> it should be supported by FOREACH statement in PL/pgSQL
>
> Oh, good idea. It would only work for discrete ranges though.
>
> However, I would need to somehow reintroduce the concept of "next",
> which has some hazards to it (as Tom pointed out, we don't want someone
> to define the "next" for a float to be "+1.0"). I'll have to think about
> this.

we can define a step

FOREACH x IN RANGE ..... BY ....
LOOP
END LOOP

Regards

Pavel

>
> Regards,
>        Jeff Davis
>
>


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Range Types and extensions
Next
From: Tom Lane
Date:
Subject: Re: Postmaster holding unlinked files for pg_largeobject table