Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #533

Re: How to select val from range of integers

Path csiph.com!usenet.pasdenom.info!goblin1!goblin.stu.neva.ru!news.task.gda.pl!not-for-mail
From jacki <collector@idealan.pl>
Newsgroups comp.databases.postgresql
Subject Re: How to select val from range of integers
Date Wed, 15 Jan 2014 10:10:15 +0100
Organization CI TASK http://www.task.gda.pl/
Lines 10
Message-ID <lb5j9m$r2p$1@news.task.gda.pl> (permalink)
References <lb5hmb$oug$1@news.task.gda.pl> <m2txd5ty28.fsf@2ndQuadrant.fr>
NNTP-Posting-Host siec.idealan.pl
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding 7bit
X-Trace news.task.gda.pl 1389777014 27737 178.212.144.2 (15 Jan 2014 09:10:14 GMT)
X-Complaints-To abuse@news.task.gda.pl
NNTP-Posting-Date Wed, 15 Jan 2014 09:10:14 +0000 (UTC)
User-Agent Mozilla/5.0 (Windows NT 6.3; rv:24.0) Gecko/20100101 Thunderbird/24.2.0
In-Reply-To <m2txd5ty28.fsf@2ndQuadrant.fr>
Xref csiph.com comp.databases.postgresql:533

Show key headers only | View raw


W dniu 2014-01-15 10:05, Dimitri Fontaine pisze:
> jacki <collector@idealan.pl> writes:
>> How can i select val from range of integers, something like:
>> SELECT VAL FROM (VALUES(1), (2), (3), ..., (10000));
>
> See generate_series().
>

Thank You very much, works perfectly!

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

How to select val from range of integers jacki <collector@idealan.pl> - 2014-01-15 09:42 +0100
  Re: How to select val from range of integers Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-01-15 10:05 +0100
    Re: How to select val from range of integers jacki <collector@idealan.pl> - 2014-01-15 10:10 +0100

csiph-web