Re: pg_generate_sequence and info_schema patch (Was: SELECT

Gaetano Mendola wrote:
> select * from generate_series(5,1,-2);

> I understood on your past posts that instead this result
> was obtained with:
>
> select * from generate_series(5,1,2);
> ~ generate_series
> - -----------------
> ~               5
> ~               3
> ~               1
> (3 rows)

Tom objected to the original, so what you now see is what was agreed upon.

> ~  ( step can not be 0 )
>
> if ( start < end ) and ( step < 0 ) the result set is empty
> if ( start > end ) and ( step > 0 ) the result set is empty

Reread the thread. That was the conclusion and what the proposed
documentation is at least trying to convey. As Tom pointed out earlier,
I need to add a bit more detail to it.

Joe