create a 'range' of dates/numbers?

From: Erwin Moller <erwin(at)darwine(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: create a 'range' of dates/numbers?
Date: 2008-12-19 10:28:04
Message-ID: 494B7734.6090102@darwine.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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.
eg:
[wrong/fantasy syntax]
SELECT (1 to 3 step 1) as number;
desired output:
number
1
2
3

I have been looking through the manual, but cannot find anything. Maybe
it doesn't exist.

Thanks for your time.

Regards,
Erwin Moller

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-12-19 10:32:18 Re: create a 'range' of dates/numbers?
Previous Message Allan Kamau 2008-12-19 10:04:04 Re: How are locks managed in PG?