Re: SYNTAX ERROR ON FOR... LOOP

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Rodrigo Carvalhaes <grupos(at)carvalhaes(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Date: 2005-04-27 18:00:04
Message-ID: 20050427180004.GA68083@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message George Weaver 2005-04-27 18:04:11 Re: SYNTAX ERROR ON FOR... LOOP
Previous Message Rodrigo Carvalhaes 2005-04-27 17:39:53 SYNTAX ERROR ON FOR... LOOP