pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rodrigo Carvalhaes <grupos@carvalhaes.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Date: Wed, 27 Apr 2005 16:27:09 -0300
Message-ID: <426FE78D.3040407@carvalhaes.net> (raw)
In-Reply-To: <24769.1114625806@sss.pgh.pa.us>
References: <426FCE69.6070805@carvalhaes.net>
	<24769.1114625806@sss.pgh.pa.us>

<!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>



view thread (5+ messages)

Message-ID: <426FE78D.3040407@carvalhaes.net>
Permalink:  ../426FE78D.3040407@carvalhaes.net/
Also on:    postgresql.org/message-id/426FE78D.3040407@carvalhaes.net

 · 

reply
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: grupos@carvalhaes.net, tgl@sss.pgh.pa.us
  Subject: Re: SYNTAX ERROR ON FOR... LOOP
  In-Reply-To: <426FE78D.3040407@carvalhaes.net>

* 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