Re: Range Types and extensions

2011/6/6 Jeff Davis <pgsql(at)j-davis(dot)com>:
> On Mon, 2011-06-06 at 06:56 +0200, Pavel Stehule wrote:
>> 2011/6/6 Darren Duncan <darren(at)darrenduncan(dot)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
>
>