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

From Christopher Kings-Lynne
Subject Re: pg_generate_sequence and info_schema patch (Was: SELECT
Date
Msg-id 40209AD6.7030207@familyhealth.com.au
Whole thread Raw
In response to Re: pg_generate_sequence and info_schema patch (Was: SELECT Question)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_generate_sequence and info_schema patch (Was: SELECT
List pgsql-patches
> I think you can provide a precise specification without losing
> simplicity of explanation.  Maybe something like
>
>    When step is positive, zero rows are returned if start > stop.
>    Conversely, when step is negative, zero rows are returned if
>    start < stop.  It is an error for step to be zero.

Having something that generates a list of dates would be handy, however
I guess you can do it with the current series generator by adding that
many day intervals to a base date...

Chris


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_generate_sequence and info_schema patch (Was: SELECT Question)
Next
From: "Magnus Hagander"
Date:
Subject: win32 signals, part 4