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  (Gaetano Mendola <mendola@bigfoot.com>)
Список 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 по дате отправления:

Предыдущее
От: Claudio Natoli
Дата:
Сообщение: Re: win32 signals, part 4
Следующее
От: Claudio Natoli
Дата:
Сообщение: win32 inode fix