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


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to