X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 20DBED1C9B3 for ; Fri, 8 Aug 2003 17:42:27 +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 61532-08 for ; Fri, 8 Aug 2003 14:40:59 -0300 (ADT) Received: from joeconway.com (66-146-172-86.skyriver.net [66.146.172.86]) by svr1.postgresql.org (Postfix) with ESMTP id B38DDD1C984 for ; Fri, 8 Aug 2003 14:42:15 -0300 (ADT) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.6) with ESMTP-TLS id 26601; Fri, 08 Aug 2003 10:02:41 -0700 Message-ID: <3F33DFFB.7010909@joeconway.com> Date: Fri, 08 Aug 2003 10:38:03 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: josh@agliodbs.com Cc: Bruce Momjian , PostgreSQL-development Subject: Re: TODO items References: <200308081713.h78HD6h00928@candle.pha.pa.us> <200308081022.22741.josh@agliodbs.com> In-Reply-To: <200308081022.22741.josh@agliodbs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/502 X-Sequence-Number: 42160 Josh Berkus wrote: >>>Actually, now that I look at it again, it is referring to procedures, >>>not functions. Maybe just make it: >>> >>>o Add capability to create and call PROCEDURES > > OK. I need to put a full proposal behind this once 7.4 is in the can. > However, this is largely academic until we get someone who really wants to > take ownership of PL/pgSQL and has the coding skills (I have the former but > not the latter). > This isn't isolated to just PL/pgSQL, just like the ability to create and call functions isn't. Support for PROCEDUREs in the backend is a prerequisite to being able to use PL/pgSQL to create procedures. It is necessary but not sufficient. Similarly, if we want to support IN/OUT or named parameters, it isn't a PL/pgSQL issue per se, it is a general one. Joe