Thread: Select (1-3)

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
----------



-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=                                 Atenciosamente
(Sincerely)                      Ezequias Rodrigues da
Rocha=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

On 11/30/06, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:

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
==================================================================

Ezequias Rodrigues da Rocha wrote:
> Hi list,
> 
> It is possible to make a selection like
> 
> Select (list 1 to 1000);

Sure, use the generate_series() function.

select * from generate_series(1, 1000);

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Uow !

1 to one m

select * from generate_series(1, 1000000);

In 5203 miliseconds (that's a great performmance). My server is not
quite good but the performance was great for me.

Thank you so much

Ezequias

2006/11/30, Aaron Bono <postgresql@aranya.com>:
> 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
> ==================================================================


-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=                                 Atenciosamente
(Sincerely)                      Ezequias Rodrigues da
Rocha=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/