From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Subject: Re: For loop
Date: Tue, 13 Mar 2007 06:44:20 -0700
User-Agent: KMail/1.9.1
References: <45F69D7C.4070304@fastcon.com.br>
	<45F6B4EB.A3DD.0030.0@indicator.be>
	<45F6A793.1090904@fastcon.com.br>
In-Reply-To: <45F6A793.1090904@fastcon.com.br>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200703130644.20870.aklaver@comcast.net>

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.
-- 
Adrian Klaver
aklaver@comcast.net