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

Path csiph.com!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups comp.databases.postgresql
Subject Re: How to select val from range of integers
Date Wed, 15 Jan 2014 10:05:19 +0100
Organization A noiseless patient Spider
Lines 10
Message-ID <m2txd5ty28.fsf@2ndQuadrant.fr> (permalink)
References <lb5hmb$oug$1@news.task.gda.pl>
Mime-Version 1.0
Content-Type text/plain
Injection-Info mx05.eternal-september.org; posting-host="1b472d18b0e4b3eae3fd1bbab54d56a6"; logging-data="2439"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/k3dh919WVYpqMyJEfYJEi"
User-Agent Gnus/5.130008 (Ma Gnus v0.8) Emacs/24.3 (darwin)
Cancel-Lock sha1:07ZtUGjkfmEII74R+5y55NJBaPU= sha1:aYCJzvWL+/E1eeb56p6c5bY3q/Y=
Xref csiph.com comp.databases.postgresql:532

Show key headers only | 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