Hi Rodrigo,
----- Original Message ----- From: "Rodrigo Carvalhaes" <[EMAIL PROTECTED]>
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;
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]