On 09/10/2008 21:25, Stephan Szabo wrote: > I think you'd end up wanting something like: > FROM ( select a * interval '1 minute' from generate_series(0, TotalMins, > mins_delta) as s(a) ) as s(a) > > I changed the concatenation and cast into an interval multiply, but you > could easily do things the other way as well.
Great - thanks! I also came up with the following after posting, when the brain finally kicked into gear :-) select start_time + cast(s.a::text || ' minutes' as interval) from generate_series(0, TotalMins, mins_delta) as s(a) Thanks for the help. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
