Postgres Pro
Downloads
Home   >   mailing lists

Re: SYNTAX ERROR ON FOR... LOOP - Mailing list pgsql-sql

From Tom Lane
Subject Re: SYNTAX ERROR ON FOR... LOOP
Date
Msg-id 24769.1114625806@sss.pgh.pa.us
Whole thread Raw
In response to SYNTAX ERROR ON FOR... LOOP  (Rodrigo Carvalhaes <grupos@carvalhaes.net>)
Responses Re: SYNTAX ERROR ON FOR... LOOP  (Rodrigo Carvalhaes <grupos@carvalhaes.net>)
List pgsql-sql
Tree view 
Rodrigo Carvalhaes <grupos@carvalhaes.net> writes:
> I am trying to make an IF / ELSE / END IF inside of a FOR ... LOOP but I 
> am getting syntax error on this contol structure...
> If I comment the IF / ELSE / ENDIF the fuction works ...

plpgsql wants "END IF" not "ENDIF".
        regards, tom lane

pgsql-sql by date:

Previous
From: George Weaver
Date:
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Next
From: Rodrigo Carvalhaes
Date:
Subject: Re: SYNTAX ERROR ON FOR... LOOP