create a 'range' of dates/numbers?

Поиск
Список
Период
Сортировка
От Erwin Moller
Тема create a 'range' of dates/numbers?
Дата
Msg-id 494B7734.6090102@darwine.nl
обсуждение исходный текст
Ответы Re: create a 'range' of dates/numbers?  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Re: create a 'range' of dates/numbers?  (Raymond O'Donnell <rod@iol.ie>)
Re: create a 'range' of dates/numbers?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: create a 'range' of dates/numbers?  (Thomas Markus <t.markus@proventis.net>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Allan Kamau"
Дата:
Сообщение: Re: How are locks managed in PG?
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: create a 'range' of dates/numbers?