On Mon, Oct 05, 2009 at 12:03:38AM +0000, Tim Landscheidt wrote: > Sam Mason <s...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
