| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Joe Conway <mail(at)joeconway(dot)com>, Kris Jurka <books(at)ejurka(dot)com>, Alex <alex(at)meerkatsoft(dot)com>, "Lada 'Ray' Lostak" <ray(at)unreal64(dot)net>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: pg_generate_sequence and info_schema patch (Was: SELECT |
| Date: | 2004-02-04 07:10:14 |
| Message-ID: | 40209AD6.7030207@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2004-02-04 07:23:29 | Re: BLOB problem |
| Previous Message | CSN | 2004-02-04 06:24:09 | RETURN NEXT and reversing order |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2004-02-04 14:33:02 | Re: pg_generate_sequence and info_schema patch (Was: SELECT |
| Previous Message | Tom Lane | 2004-02-04 06:21:44 | Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) |