try function generateseries
thomas
Erwin Moller schrieb:
> 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
>
>
--
Thomas Markus
====================================================
proventis GmbH | Zimmerstr. 79-81 | D-10117 Berlin |
Tel +49 (0)30 2936399-22 | Fax -50 | t.markus@proventis.net
-----------------------------------------------------------------
Geschäftsführer: Norman Frischmuth | Sitz: Berlin
Handelsregister: AG Berlin-Charlottenburg, HR 82917
-----------------------------------------------------------------
Blue Ant-webbasiertes Projektmanagement - aktuelle Termine 2008:
http://www.proventis.net/website/live/blueant/veranstaltungen.html
====================================================