Re: pg_generate_sequence and info_schema patch (Was: SELECT

Поиск
Список
Период
Сортировка
Искать
От
Joe Conway
Тема
Re: pg_generate_sequence and info_schema patch (Was: SELECT
Дата
Msg-id
4021CD41.5040901@joeconway.com
Ответ на
Список
Дерево обсуждения
Re: pg_generate_sequence and info_schema patch (Was: SELECT Christopher Browne <cbbrowne@acm.org>
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 по дате отправления
От: Claudio Natoli
Дата:
Сообщение: Re: win32 signals, part 4
От: Claudio Natoli
Дата:
Сообщение: win32 inode fix
FAQ