Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1F5B79FB279 for ; Fri, 24 Nov 2006 10:43:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 98260-03 for ; Fri, 24 Nov 2006 14:43:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.192.81]) by postgresql.org (Postfix) with ESMTP id 580AB9FB260 for ; Fri, 24 Nov 2006 10:43:06 -0400 (AST) Received: from [192.168.0.9] (c-24-17-161-80.hsd1.wa.comcast.net[24.17.161.80]) by comcast.net (rwcrmhc11) with ESMTP id <20061124144250m1100t7btoe>; Fri, 24 Nov 2006 14:43:04 +0000 From: Adrian Klaver Reply-To: aklaver@comcast.net To: pgsql-sql@postgresql.org Subject: Re: select into Date: Fri, 24 Nov 2006 06:45:33 -0800 User-Agent: KMail/1.6.2 Cc: Tom Lane , Mulham freshcode , "A. Kretschmer" References: <20061124042134.55885.qmail@web90512.mail.mud.yahoo.com> <28318.1164343519@sss.pgh.pa.us> In-Reply-To: <28318.1164343519@sss.pgh.pa.us> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200611240645.33431.aklaver@comcast.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.556 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200611/245 X-Sequence-Number: 26897 On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: > Mulham freshcode writes: > > execute sql_str1 into svc_data_rec ; > > > > svc_data_rec is a RECORD, which is supposed to be dynamic. > > This should work --- in PG 8.1 or later. In older versions you'd have > to fool around with a FOR ... IN EXECUTE ... loop. > > regards, tom lane The documentation for pl/pgsql in 8.1 and higher says different. http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN " SELECT INTO is not currently supported within EXECUTE." The change is reflected in the HISTORY text though. How is the best way to get a change made to the documentation? -- Adrian Klaver aklaver@comcast.net