X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 07FB5475E10 for ; Mon, 24 Feb 2003 13:49:37 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 34554-06 for ; Mon, 24 Feb 2003 13:49:26 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 04629474E4F for ; Mon, 24 Feb 2003 13:22:55 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2854952; Mon, 24 Feb 2003 10:22:53 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Tom Lane , Jeff Eckermann Subject: Re: syntax question Date: Mon, 24 Feb 2003 10:22:02 -0800 User-Agent: KMail/1.4.3 Cc: James Cooper , pgsql-sql@postgresql.org References: <20030224151740.15417.qmail@web20805.mail.yahoo.com> <3492.1046100614@sss.pgh.pa.us> In-Reply-To: <3492.1046100614@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <200302241022.02853.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/534 X-Sequence-Number: 11932 Jeff, > I think Josh meant to say you can't select the results of a *dynamically > constructed* query without a loop --- that is, you need FOR ... EXECUTE. > A plain EXECUTE doesn't support plpgsql's notion of SELECT INTO. That's correct. See the rest of the thread. --=20 Josh Berkus Aglio Database Solutions San Francisco