X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 991399DCAC0; Sun, 11 Dec 2005 12:39:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94699-02; Sun, 11 Dec 2005 12:39:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from asmodeus.mcnaught.org (sp-260-1.net4.netcentrix.net [4.21.254.118]) by postgresql.org (Postfix) with ESMTP id 6E5789DCADB; Sun, 11 Dec 2005 12:39:00 -0400 (AST) Received: from [4.21.254.71] (helo=Douglas-McNaughts-Powerbook.local) by asmodeus.mcnaught.org with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1ElUDx-0008NF-1d; Sun, 11 Dec 2005 11:38:57 -0500 To: "Foster, Stephen" Cc: "'Michael Fuhr'" , , Subject: Re: [SQL] Looking for information on PostgreSQL Stored Procedures References: <000001c5fe70$f5e51330$2101a8c0@cfgod> From: Douglas McNaught Date: Sun, 11 Dec 2005 11:38:47 -0500 In-Reply-To: <000001c5fe70$f5e51330$2101a8c0@cfgod> (Stephen Foster's message of "Sun, 11 Dec 2005 10:35:51 -0600") Message-ID: User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[UPPERCASE_25_50=0] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/531 X-Sequence-Number: 88094 "Foster, Stephen" writes: > WHILE (--Lost on variable name for end of query; EmptyQueryResponse <> > 0? --) > BEGIN > IF LastName = fname THEN > DELETE FROM MailingList WHERE id = id; > END IF; > LastName := fname; > FETCH NEXT FROM NewListCursor INTO fname, id; > END; > CLOSE NewListCursor; > $BODY$ > LANGUAGE 'sql' VOLATILE; You can't do any looping or other control structures in an SQL function. Use PL/pgSQL instead. -Doug