X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 016EAD1C9FC for ; Fri, 1 Aug 2003 20:26:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 67439-10 for ; Fri, 1 Aug 2003 17:25:10 -0300 (ADT) Received: from jalapeno.crazydogs.org (jalapeno.jellybean.co.uk [212.78.70.100]) by svr1.postgresql.org (Postfix) with ESMTP id 4CFDED1C9F9 for ; Fri, 1 Aug 2003 17:26:15 -0300 (ADT) Received: from rp by jalapeno.crazydogs.org with local (Exim 3.35 #1 (Debian)) id 19igTg-0007R1-00 for ; Fri, 01 Aug 2003 21:26:16 +0100 Date: Fri, 1 Aug 2003 21:26:16 +0100 From: Richard Poole To: pgsql-sql@postgresql.org Subject: Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Message-ID: <20030801202616.GA17793@guests.deus.net> References: <200307310412.h6V4CNt25172@candle.pha.pa.us> <200308011516.56947.xzilla@users.sourceforge.net> <200308011306.18747.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200308011306.18747.josh@agliodbs.com> User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/15 X-Sequence-Number: 14631 On Fri, Aug 01, 2003 at 01:06:18PM -0700, Josh Berkus wrote: > As far as I can tell from my PL/SQL guide to Oracle8, PL/SQL does not permit > exectution of strings-as-queries at all. So there's no equivalent in PL/SQL. I'm not an Oracle bunny but they seem to have something vaguely similar to what we do; they call it "EXECUTE IMMEDIATE" and the concept is described as "Dynamic SQL". http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a77069/10_dynam.htm#4376 Richard