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