Sam Mason <sam@xxxxxxxxxxxxx> 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. (I obviously meant "(B - A) / C" :-).) Is it? I would assume that you just have to convert A, B and C to seconds (since epoch) and then use a normal integer division. > [...] >> "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. My knowledge of PostgreSQL's codebase is nonexistent, so I do not know how unstable it is. Tim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
