Re: SYNTAX ERROR ON FOR... LOOP - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: SYNTAX ERROR ON FOR... LOOP
Date
Msg-id 20050427180004.GA68083@winnie.fuhr.org
Whole thread Raw
In response to SYNTAX ERROR ON FOR... LOOP  (Rodrigo Carvalhaes <grupos@carvalhaes.net>)
List pgsql-sql
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 $$;
> ELSE
> vstrupdate := vstrupdate || $$ IS false $$;
> ENDIF;

The above should be "END IF" (with a space).

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: Rodrigo Carvalhaes
Date:
Subject: SYNTAX ERROR ON FOR... LOOP
Next
From: George Weaver
Date:
Subject: Re: SYNTAX ERROR ON FOR... LOOP