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 <[EMAIL PROTECTED]>:
On 11/30/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
