Re: Feature request: Improve allowed values for generate series - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Feature request: Improve allowed values for generate series
Date
Msg-id CAKFQuwYSc-wvfrzh8gGXEGeeiVxOUJXAKVziv83Ev92TCoEYhQ@mail.gmail.com
Whole thread Raw
In response to Feature request: Improve allowed values for generate series  (Eugen Konkov <kes-kes@yandex.ru>)
List pgsql-hackers
On Wed, Nov 11, 2020 at 11:59 AM Eugen Konkov <kes-kes@yandex.ru> wrote:
So   I   feature  request  to  allow  zero size step for cases when  start point is equest to finish

What do you think?

I don't see how this is useful.  If they are equal and you use a non-zero step you get back the one record you are looking for anyway, plus the non-zero step allows them to be unequal.  If zero step is allowed it is only useful for when they are equal, being undefined when they are unequal.

David J.


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Feature request: Improve allowed values for generate series
Next
From: "David G. Johnston"
Date:
Subject: Re: Feature request: Improve allowed values for generate series