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 D73B53A4838 for ; Mon, 22 Nov 2004 01:03:41 +0000 (GMT) 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 18085-01 for ; Mon, 22 Nov 2004 01:03:37 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 342CA3A406F for ; Mon, 22 Nov 2004 01:03:38 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iAM13XYT001450; Sun, 21 Nov 2004 20:03:33 -0500 (EST) To: Justine.Cleary@c1data.com Cc: pgsql-sql@postgresql.org Subject: Re: missing... at end of sql expression In-reply-to: <07CF70EF155E0F46B8C658298805581DD2E264@srvexchcheyenne.c1data.com> References: <07CF70EF155E0F46B8C658298805581DD2E264@srvexchcheyenne.c1data.com> Comments: In-reply-to Justine.Cleary@c1data.com message dated "Thu, 18 Nov 2004 12:28:03 -0700" Date: Sun, 21 Nov 2004 20:03:33 -0500 Message-ID: <1449.1101085413@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/221 X-Sequence-Number: 19540 Justine.Cleary@c1data.com writes: > I am trying to learn pspgsql but I am not having a lot of luck. > I have written a function but I keep getting the error missing... at end of > sql expression. Can anyone help! What it's really unhappy about is that you failed to declare the FOR variable; this is causing it to assume that the FOR is the integer variant (FOR i IN low .. high). The error message is pretty confusing, I agree. I think 8.0 will do better. regards, tom lane