Re: create a 'range' of dates/numbers?

On 19/12/2008 10:28, Erwin Moller wrote:

> Is it possible to create a range of dates or numbers inside a query
> without wrining in procedural language?
> I am looking for something that creates some kind of 'temp table' inside
> a query.

Have a look at the generate_series() function in the manual - if memory
serves, there's an example there of creating a series of dates.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------