Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ub6y7-0001FW-BC for pgsql-docs@arkaria.postgresql.org; Sat, 11 May 2013 10:23:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ub6y6-0001ii-OM for pgsql-docs@arkaria.postgresql.org; Sat, 11 May 2013 10:23:58 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ub6y5-0001ic-SF for pgsql-docs@postgresql.org; Sat, 11 May 2013 10:23:58 +0000 Received: from smtp-vbr5.xs4all.nl ([194.109.24.25]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ub6xz-00027U-5p for pgsql-docs@postgresql.org; Sat, 11 May 2013 10:23:57 +0000 Received: from webmail.xs4all.nl (dovemail19.xs4all.nl [194.109.26.21]) by smtp-vbr5.xs4all.nl (8.13.8/8.13.8) with ESMTP id r4BANlvQ013705; Sat, 11 May 2013 12:23:47 +0200 (CEST) (envelope-from er@xs4all.nl) Received: from 83.163.19.29 (SquirrelMail authenticated user er) by webmail.xs4all.nl with HTTP; Sat, 11 May 2013 12:23:47 +0200 Message-ID: In-Reply-To: <518C0B2B.9040909@falter.at> References: <518C0B2B.9040909@falter.at> Date: Sat, 11 May 2013 12:23:47 +0200 Subject: Re: Reference function arguments by name From: "Erik Rijkers" To: "Erwin Brandstetter" Cc: pgsql-docs@postgresql.org User-Agent: SquirrelMail/1.4.18 MIME-Version: 1.0 Content-Type: multipart/mixed;boundary="----=_20130511122347_51301" X-Virus-Scanned: by XS4ALL Virus Scanner X-Pg-Spam-Score: -0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org ------=_20130511122347_51301 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit On Thu, May 9, 2013 22:46, Erwin Brandstetter wrote: > This has changed in version 9.2. SQL functions can reference the name. Ergo: > > s /(currently only PL/pgSQL) / (currently only PL/pgSQL and SQL) > > Here is the patch (don't feed them Battenbergs). ------=_20130511122347_51301 Content-Type: application/octet-stream; name="sql-createfunction.diff" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="sql-createfunction.diff" LS0tIGRvYy9zcmMvc2dtbC9odG1sL3NxbC1jcmVhdGVmdW5jdGlvbi5odG1s Lm9yaWcJMjAxMy0wNS0xMSAxMjoxOTo1OC41NzkzMjY4MjUgKzAyMDAKKysr IGRvYy9zcmMvc2dtbC9odG1sL3NxbC1jcmVhdGVmdW5jdGlvbi5odG1sCTIw MTMtMDUtMTEgMTI6MjA6NTEuNTEwMDA0NDM2ICswMjAwCkBAIC0zODksNyAr Mzg5LDcgQEAKID48L0RUCiA+PERECiA+PFAKLT4gICAgICAgVGhlIG5hbWUg b2YgYW4gYXJndW1lbnQuIFNvbWUgbGFuZ3VhZ2VzIChjdXJyZW50bHkgb25s eSBQTC9wZ1NRTCkgbGV0Cis+ICAgICAgIFRoZSBuYW1lIG9mIGFuIGFyZ3Vt ZW50LiBTb21lIGxhbmd1YWdlcyAoY3VycmVudGx5IG9ubHkgUEwvcGdTUUwg YW5kIFNRTCkgbGV0CiAgICAgICAgeW91IHVzZSB0aGUgbmFtZSBpbiB0aGUg ZnVuY3Rpb24gYm9keS4gIEZvciBvdGhlciBsYW5ndWFnZXMgdGhlCiAgICAg ICAgbmFtZSBvZiBhbiBpbnB1dCBhcmd1bWVudCBpcyBqdXN0IGV4dHJhIGRv Y3VtZW50YXRpb24sIHNvIGZhciBhcwogICAgICAgIHRoZSBmdW5jdGlvbiBp dHNlbGYgaXMgY29uY2VybmVkOyBidXQgeW91IGNhbiB1c2UgaW5wdXQgYXJn dW1lbnQgbmFtZXMK ------=_20130511122347_51301 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ------=_20130511122347_51301--