Groups > comp.databases.postgresql > #533

Re: How to select val from range of integers

From	jacki <collector@idealan.pl>
Newsgroups	comp.databases.postgresql
Subject	Re: How to select val from range of integers
Date	2014-01-15 10:10 +0100
Organization	CI TASK http://www.task.gda.pl/
Message-ID	<lb5j9m$r2p$1@news.task.gda.pl> (permalink)
References	<lb5hmb$oug$1@news.task.gda.pl> <m2txd5ty28.fsf@2ndQuadrant.fr>

Show all headers | 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