Uow !
1 to one m
select * from generate_series(1, 100);
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 <[
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 Herrerahttp://www.CommandPrompt.com/
PostgreSQL Re
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://oreilly
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 (Sincere
