Re: SYNTAX ERROR ON FOR... LOOP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: grupos(at)carvalhaes(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Date: 2005-04-27 18:16:46
Message-ID: 24769.1114625806@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rodrigo Carvalhaes <grupos(at)carvalhaes(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo Carvalhaes 2005-04-27 19:27:09 Re: SYNTAX ERROR ON FOR... LOOP
Previous Message George Weaver 2005-04-27 18:04:11 Re: SYNTAX ERROR ON FOR... LOOP