Re: Procedure for feature requests?
От | Sam Mason |
---|---|
Тема | Re: Procedure for feature requests? |
Дата | |
Msg-id | 20091005102722.GQ5407@samason.me.uk обсуждение исходный текст |
Ответ на | Re: Procedure for feature requests? (Tim Landscheidt <tim@tim-landscheidt.de>) |
Список | pgsql-general |
On Mon, Oct 05, 2009 at 12:03:38AM +0000, Tim Landscheidt wrote: > Sam Mason <sam@samason.me.uk> wrote: > >Tim Landscheidt wrote: > >> "generate_series(A, B, C)" can also > >> be written as "A + generate_series(0, (C - B) / C) * C" > > > > If you can figure out the limit then it seems easy, > > though I'm not sure how you'd do that. > > What limit? Sorry, I was calling the second parameter to generate_series the "limit". Calculating "(C - B) / C" isn't easy for timestamps, whereas it's easy for dates. I believe this is why there's a specific version for the former but not the latter. > > Hum, now I'll have to see which is "better". > > Which of my mails made you think that I was not satisfied > with PostgreSQL's current performance? Nothing, it's was my personal interest to see which was faster. > "generate_series(DATE, DATE)" would just be syntactic sugar, > and I like sweets. We all do, but in software it's got to be balanced against the overhead of maintaining support for these functions. -- Sam http://samason.me.uk/
В списке pgsql-general по дате отправления: