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@postgresql.org
<mailto:pgsql-sql@postgresql.org>
"Ezequias R. da Rocha" <[EMAIL PROTECTED]> 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.
