From: George Weaver <gweaver@shaw.ca>
To: grupos@carvalhaes.net
To: pgsql-sql@postgresql.org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Date: Wed, 27 Apr 2005 13:04:11 -0500
Message-ID: <008b01c54b53$89839d40$6400a8c0@Dell4500> (raw)
References: <426FCE69.6070805@carvalhaes.net>
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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gweaver@shaw.ca, grupos@carvalhaes.net
Subject: Re: SYNTAX ERROR ON FOR... LOOP
In-Reply-To: <008b01c54b53$89839d40$6400a8c0@Dell4500>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox