Re: Feature request: Improve allowed values for generate series

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Eugen Konkov <kes-kes(at)yandex(dot)ru>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Feature request: Improve allowed values for generate series
Date: 2020-11-11 19:10:58
Message-ID: CAKFQuwYSc-wvfrzh8gGXEGeeiVxOUJXAKVziv83Ev92TCoEYhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 11, 2020 at 11:59 AM Eugen Konkov <kes-kes(at)yandex(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2020-11-11 19:17:04 Re: Add session statistics to pg_stat_database
Previous Message Pavel Stehule 2020-11-11 19:07:28 Re: Feature request: Improve allowed values for generate series