Re: [SQL] SYNTAX ERROR ON FOR... LOOP

2005-04-27 Thread Rodrigo Carvalhaes
Guys, sometimes I make stupid things... I t was the END IF as all of you said... Thanks for your exists. Cheers, Rodrigo Tom Lane wrote: Rodrigo Carvalhaes <[EMAIL PROTECTED]> writes: I am trying to make an IF / ELSE / END IF inside of a FOR ... LOOP but I am getting syntax

Re: [SQL] SYNTAX ERROR ON FOR... LOOP

2005-04-27 Thread Tom Lane
Rodrigo Carvalhaes <[EMAIL PROTECTED]> 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". r

Re: [SQL] SYNTAX ERROR ON FOR... LOOP

2005-04-27 Thread George Weaver
Hi Rodrigo, - Original Message - From: "Rodrigo Carvalhaes" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 27, 2005 12:39 PM Subject: [SQL] SYNTAX ERROR ON FOR... LOOP Hi Guys, I am having a "simple syntax problem" but very strange... I am trying to make an IF

Re: [SQL] SYNTAX ERROR ON FOR... LOOP

2005-04-27 Thread Michael Fuhr
On Wed, Apr 27, 2005 at 02:39:53PM -0300, Rodrigo Carvalhaes wrote: > > 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... [snip] > IF records.is_customer IS FALSE THEN > vstrupdate := vstrupdate || $$ IS true $$; > ELS

[SQL] SYNTAX ERROR ON FOR... LOOP

2005-04-27 Thread Rodrigo Carvalhaes
Hi Guys, I am having a "simple syntax problem" but very strange... 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 ... I am using PostgreSQL win 8.0 Any tip ? :-D The