Re: SYNTAX ERROR ON FOR... LOOP

Hi Rodrigo,

----- Original Message -----
From: "Rodrigo Carvalhaes" <grupos(at)carvalhaes(dot)net>
To: <pgsql-sql(at)postgresql(dot)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;