Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpUjD-0007rJ-Qk for pgsql-docs@arkaria.postgresql.org; Thu, 20 Jun 2013 02:36:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UpUjC-0001lQ-45 for pgsql-docs@arkaria.postgresql.org; Thu, 20 Jun 2013 02:36:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpUj5-0001cM-Kc for pgsql-docs@postgresql.org; Thu, 20 Jun 2013 02:35:55 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UpUj2-0002at-2v for pgsql-docs@postgresql.org; Thu, 20 Jun 2013 02:35:55 +0000 Received: from mailout-de.gmx.net ([10.1.76.33]) by mrigmx.server.lan (mrigmx001) with ESMTP (Nemesis) id 0MFwhE-1V3EFV1VBO-00Er4k for ; Thu, 20 Jun 2013 04:35:51 +0200 Received: (qmail invoked by alias); 20 Jun 2013 02:35:51 -0000 Received: from pool-108-2-72-47.phlapa.fios.verizon.net (EHLO [192.168.1.8]) [108.2.72.47] by mail.gmx.net (mp033) with SMTP; 20 Jun 2013 04:35:51 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+fc2B6Up2fv3jXdVc33HQck5uTVK0dNElCMmU81B QX9Nq7HjnPFw3s Message-ID: <1371695748.13762.41.camel@vanquo.pezone.net> Subject: Re: Reference function arguments by name From: Peter Eisentraut To: Tom Lane Cc: Erwin Brandstetter , pgsql-docs@postgresql.org Date: Wed, 19 Jun 2013 22:35:48 -0400 In-Reply-To: <1371525315.13762.12.camel@vanquo.pezone.net> References: <518C0B2B.9040909@falter.at> <18362.1368288613@sss.pgh.pa.us> <1371525315.13762.12.camel@vanquo.pezone.net> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4-3 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -3.2 (---) 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 On Mon, 2013-06-17 at 23:15 -0400, Peter Eisentraut wrote: > On Sat, 2013-05-11 at 12:10 -0400, Tom Lane wrote: > > Erwin Brandstetter writes: > > > The manual says here: > > > http://www.postgresql.org/docs/current/interactive/sql-createfunction.html > > > > >> The name of an argument. Some languages (currently only PL/pgSQL) > > >> let you use the name in the function body. For other languages the > > > > > This has changed in version 9.2. SQL functions can reference the name. > > > > Ah, this comment got missed when updating the docs for that feature. > > Fixed, thanks for spotting it! > > According to https://wiki.postgresql.org/wiki/PL_Matrix, several other > languages support named parameters. Maybe the parenthetical remark > should be removed altogether. Fixed, and also updated the equally wrong claim in 8.4...9.1 that only PL/pgSQL supports this. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs