On Fri, Feb 17, 2006 at 04:07:28PM -0500, Henry Ortega wrote: > Is there a real quick way to do a query that will show me all the dates > given a startdate and an end date?
You could use generate_series(), which is built-in since 8.0 and easily written in earlier versions. SELECT date'2006-02-01' + x FROM generate_series(0, date'2006-02-28' - date'2006-02-01') AS g(x); -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq