Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9G9AJP63406 for ; Tue, 16 Oct 2001 05:10:20 -0400 (EDT) (envelope-from olly@lfix.co.uk) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 15tQEp-0004EU-0V; Tue, 16 Oct 2001 10:10:17 +0100 Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.12.1/8.12.1/Debian -2) with ESMTP id f9G8bNPo013820; Tue, 16 Oct 2001 09:37:26 +0100 Message-Id: <200110160837.f9G8bNPo013820@linda.lfix.co.uk> X-Mailer: exmh version 2.3.1 01/18/2001 (debian 2.3.1-1) with nmh-1.0.4+dev X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: pgsql-sql@postgresql.org Subject: Re: EXECUTE ... INTO? In-reply-to: Message from "Josh Berkus" of Mon, 15 Oct 2001 12:41:52 PDT. Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 16 Oct 2001 09:37:23 +0100 From: "Oliver Elphick" X-Archive-Number: 200110/203 X-Sequence-Number: 5158 "Josh Berkus" wrote: >Folks, > >Can anybody tell me the syntax for sending the result of an EXECUTE to a >variable within a PL/pgSQL function again? Jan Wieck posted it to the >list this summer, but the "searchable list archives" are bogging down. FOR variable IN EXECUTE ''SELECT ...'' LOOP END LOOP; -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "But be ye doers of the word, and not hearers only, deceiving your own selves." James 1:22