Re: For loop

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.

Sincerely
Ezequias
Adrian Klaver escreveu:
> On Tuesday 13 March 2007 6:30 am, Ezequias R. da Rocha wrote:
>
>> I quetion one more time. I must have a function ? Isn't another way to
>> implement it without using functions ?
>>
>> Ezequias
>>
>> Bart Degryse escreveu:
>>
>>> Please post your complete CREATE FUNCTION statement. Error code 42601
>>> refers to some syntax error which probably occurs just before you
>>> start looping. To find it I need to see more code.
>>> Please don't mail me directly. Only mail to pgsql-sql(at)postgresql(dot)org
>>> <mailto:pgsql-sql(at)postgresql(dot)org>
>>>
>>>
>>>>>> "Ezequias R. da Rocha" <ezequias(at)fastcon(dot)com(dot)br> 2007-03-13 14:19 >>>
>>>>>>
>>> They are not working well.
>>>
>>> Allways the same error.
>>>
>>> (if while)
>>> ERROR: syntax error at or near "WHILE"
>>> SQL state: 42601
>>> Character: 1
>>>
>>> (if for)
>>>
>>> ERROR: syntax error at or near "FOR"
>>> SQL state: 42601
>>> Character: 1
>>>
>>> (if loop)
>>> ERROR: syntax error at or near "LOOP"
>>> SQL state: 42601
>>> Character: 1
>>> I installed the pgsql but I don't think it is a problem of language.
>>> What could be wrong ? I am not using functions too. I am using the SQL
>>> tool of PgAdmin III.
>>>
>>> Any help would be glad.
>>>
>>> Ezequias
>>>
>>>
> If you want to use plpgsql it needs to be within a function.
>