Re: pg_generate_sequence and info_schema patch (Was: SELECT - Mailing list pgsql-patches

From Joe Conway
Subject Re: pg_generate_sequence and info_schema patch (Was: SELECT
Date
Msg-id 4021CD41.5040901@joeconway.com
Whole thread Raw
In response to Re: pg_generate_sequence and info_schema patch (Was: SELECT  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-patches
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


pgsql-patches by date:

Previous
From: Claudio Natoli
Date:
Subject: Re: win32 signals, part 4
Next
From: Claudio Natoli
Date:
Subject: win32 inode fix