From: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
---|---|
To: | Erwin Moller <erwin(at)darwine(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: create a 'range' of dates/numbers? |
Date: | 2008-12-19 10:43:22 |
Message-ID: | 494B7ACA.1090500@proventis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)markus(at)proventis(dot)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
====================================================
Attachment | Content-Type | Size |
---|---|---|
t_markus.vcf | text/x-vcard | 255 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Moller | 2008-12-19 10:43:53 | Re: create a 'range' of dates/numbers? |
Previous Message | Thomas Kellerer | 2008-12-19 10:40:23 | Re: How are locks managed in PG? |