Re: Select (1-3)

["Aaron Bono" <postgresql(at)aranya(dot)com>]

On 11/30/06, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)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
==================================================================