X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A0B9535D8; Mon, 18 Apr 2005 14:26:53 -0300 (ADT) 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 01822-04; Mon, 18 Apr 2005 17:26:50 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 34790533CB; Mon, 18 Apr 2005 14:26:49 -0300 (ADT) 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 j3IHQnGW023849; Mon, 18 Apr 2005 13:26:50 -0400 (EDT) To: dpandey@secf.com Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: 'Select INTO" in Execute (dynamic query ) In-reply-to: <20050418160800.A5165534BF@svr1.postgresql.org> References: <20050418160800.A5165534BF@svr1.postgresql.org> Comments: In-reply-to "Dinesh Pandey" message dated "Mon, 18 Apr 2005 21:34:48 +0530" Date: Mon, 18 Apr 2005 13:26:49 -0400 Message-ID: <23848.1113845209@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/723 X-Sequence-Number: 76636 "Dinesh Pandey" writes: > What's wrong with this code (ERROR: syntax error at or near "INTO" at > character 8)? You can't use plpgsql's SELECT INTO in an EXECUTE'd command, because SELECT INTO means something entirely different to the main SQL engine. The usual workaround is to use FOR ... IN EXECUTE. See the plpgsql docs. regards, tom lane