Postgres Pro
Downloads
Home   >   mailing lists

Re: Select (1-3) - Mailing list pgsql-sql

From Aaron Bono
Subject Re: Select (1-3)
Date
Msg-id bf05e51c0611301035l42fa2178n398c3fc2c281ead2@mail.gmail.com
Whole thread Raw
In response to Select (1-3)  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Responses Re: Select (1-3)
List pgsql-sql
Tree view
On 11/30/06, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
Hi list,

It is possible to make a selection like

Select (list 1 to 1000);

And get the rows ?

producao=# select ...;
   row
---------
   1
   2
   3
.
.
.
1000

select * from generate_series(1, 1000);

See http://oreillynet.com/pub/a/databases/2006/09/07/plpgsql-batch-updates.html?page=2

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-sql by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Select (1-3)
Next
From: Alvaro Herrera
Date:
Subject: Re: Select (1-3)