Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 38B8C9FB60B for ; Tue, 13 Mar 2007 10:28:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 13342-05 for ; Tue, 13 Mar 2007 10:28:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id DD3719FB600 for ; Tue, 13 Mar 2007 10:28:35 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-201-67.bk11-dsl.surnet.cl [201.221.201.67]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l2DDSQ7m020823; Tue, 13 Mar 2007 06:28:27 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id BCDD632A15; Tue, 13 Mar 2007 09:28:24 -0400 (CLT) Date: Tue, 13 Mar 2007 09:28:24 -0400 From: Alvaro Herrera To: "Ezequias R. da Rocha" Cc: Bart Degryse , pgsql-sql@postgresql.org Subject: Re: For loop Message-ID: <20070313132824.GA6715@alvh.no-ip.org> Mail-Followup-To: "Ezequias R. da Rocha" , Bart Degryse , pgsql-sql@postgresql.org References: <45F6B1A2.A3DD.0030.0@indicator.be> <45F6A4E5.7090707@fastcon.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45F6A4E5.7090707@fastcon.com.br> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 13 Mar 2007 06:28:27 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/157 X-Sequence-Number: 27795 Ezequias R. da Rocha wrote: > They are not working well. > > Allways the same error. > > (if while) > ERROR: syntax error at or near "WHILE" > SQL state: 42601 > Character: 1 You may have a problem in the code just _before_ these lines. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.