Re: SYNTAX ERROR ON FOR... LOOP

Hi Rodrigo,


----- Original Message ----- 
From: "Rodrigo Carvalhaes" <grupos@carvalhaes.net>
To: <pgsql-sql@postgresql.org>
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 / 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 ...
>
snip

> vstrupdate := $$UPDATE table1 SET code = $$ || new_code ||
> $$ WHERE old_code = $$ || recs.old_code || $$ AND is_customer $$;
>
> IF records.is_customer IS FALSE THEN
> vstrupdate := vstrupdate || $$ IS true ;$$;                                                         ^^^^
I believe you need an ";" after true and false to complete the string as an 
SQL statement

> ELSE
> vstrupdate := vstrupdate || $$ IS false ;$$;                                                       ^^^^

> ENDIF;
>
> EXECUTE vstrupdate;