Re: SYNTAX ERROR ON FOR... LOOP

From: Rodrigo Carvalhaes <grupos(at)carvalhaes(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SYNTAX ERROR ON FOR... LOOP
Date: 2005-04-27 19:27:09
Message-ID: 426FE78D.3040407@carvalhaes.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<!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(dot)1114625806(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Rodrigo Carvalhaes <a class="moz-txt-link-rfc2396E" href="mailto:grupos(at)carvalhaes(dot)net">&lt;grupos(at)carvalhaes(dot)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>

Attachment Content-Type Size
unknown_filename text/html 1.4 KB

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ramakrishnan Muralidharan 2005-04-28 05:13:45 Re: trigger/rule question
Previous Message Tom Lane 2005-04-27 18:16:46 Re: SYNTAX ERROR ON FOR... LOOP