Re: For loop

Ezequias R. da Rocha wrote:
> Thank you all. The function from Jonah solves my problem.
> 
> Just a simple question:
> 
> One million of inserctions in *28,8* seconds with this kind of data 
> (timestamp|character varring (50))  is a good performance ?
> 
> I let my questions to DBAs from PostgreSQL.

I don't know, but Jonah's function can be better written using pure SQL,
which should be faster.  Something like this:

create table whatever (a text, b int);
insert into whatever select 'My text from iteration ' || a, a * 2 from generate_series(1, 1000000) a;

I don't claim this works as is, but you should get the hang of it.

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