X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E01F3535CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Apr 2005 16:27:37 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 97696-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Apr 2005 19:27:26 +0000 (GMT)
Received: from nitrogenio.carvalhaes.net (unknown [200.175.206.50])
	by svr1.postgresql.org (Postfix) with ESMTP id 9DAA9535AE
	for <pgsql-sql@postgresql.org>; Wed, 27 Apr 2005 16:27:24 -0300 (ADT)
Received: from [192.168.0.199] ([192.168.0.199]) (authenticated bits=0)
	by nitrogenio.carvalhaes.net (8.13.4/8.13.4) with ESMTP id
	j3RJID1n012913; Wed, 27 Apr 2005 16:18:13 -0300
Message-ID: <426FE78D.3040407@carvalhaes.net>
Date: Wed, 27 Apr 2005 16:27:09 -0300
From: Rodrigo Carvalhaes <grupos@carvalhaes.net>
Reply-To: grupos@carvalhaes.net
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
References: <426FCE69.6070805@carvalhaes.net> <24769.1114625806@sss.pgh.pa.us>
In-Reply-To: <24769.1114625806@sss.pgh.pa.us>
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Triade-MailScanner-Information: Por favor,
	entre em contato para obter detalhes
X-Triade-MailScanner: Found to be clean
X-MailScanner-From: grupos@carvalhaes.net
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.406 tagged_above=0 required=5 tests=AWL, HTML_40_50,
	HTML_MESSAGE, HTML_TEXT_AFTER_BODY, MIME_HTML_ONLY
X-Spam-Level: *
X-Archive-Number: 200504/394
X-Sequence-Number: 21287

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Guys, sometimes I make stupid things... <br>
<br>
I t was the END IF as all of you said... <br>
<br>
Thanks for your exists.<br>
<br>
Cheers,<br>
<br>
Rodrigo<br>
<br>
Tom Lane wrote:
<blockquote cite="mid24769.1114625806@sss.pgh.pa.us" type="cite">
  <pre wrap="">Rodrigo Carvalhaes <a class="moz-txt-link-rfc2396E" href="mailto:grupos@carvalhaes.net">&lt;grupos@carvalhaes.net&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">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 ...
    </pre>
  </blockquote>
  <pre wrap=""><!---->
plpgsql wants "END IF" not "ENDIF".

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               <a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/faq">http://www.postgresql.org/docs/faq</a>

  </pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 


Abra&ccedil;o,

Rodrigo Carvalhaes
DBA PostgreSQL
Moderador grupo siga-br</pre>
</body>
<br />--
<br />Esta mensagem foi verificada pelo sistema de antivírus e 
<br /> acredita-se estar livre de perigo.
</html>