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

Groups > comp.databases.postgresql > #532

Re: How to select val from range of integers

From Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups comp.databases.postgresql
Subject Re: How to select val from range of integers
Date 2014-01-15 10:05 +0100
Organization A noiseless patient Spider
Message-ID <m2txd5ty28.fsf@2ndQuadrant.fr> (permalink)
References <lb5hmb$oug$1@news.task.gda.pl>

Show all headers | View raw

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().

Regards,
-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next 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