From: Ezequias R. da Rocha <ezequias@fastcon.com.br>
To: pgsql-sql@postgresql.org
Subject: Re: For loop
Date: Tue, 13 Mar 2007 11:03:39 -0300
Message-ID: <45F6AF3B.4080706@fastcon.com.br> (raw)
In-Reply-To: <200703130644.20870.aklaver@comcast.net>
References: <45F69D7C.4070304@fastcon.com.br>
<45F6B4EB.A3DD.0030.0@indicator.be>
<45F6A793.1090904@fastcon.com.br>
<200703130644.20870.aklaver@comcast.net>
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" <ezequias@fastcon.com.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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias@fastcon.com.br
Subject: Re: For loop
In-Reply-To: <45F6AF3B.4080706@fastcon.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox