Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UomOC-0006HG-HP for pgsql-docs@arkaria.postgresql.org; Tue, 18 Jun 2013 03:15:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UomOB-00078k-EX for pgsql-docs@arkaria.postgresql.org; Tue, 18 Jun 2013 03:15:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UomOA-00078e-SB for pgsql-docs@postgresql.org; Tue, 18 Jun 2013 03:15:22 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UomO7-000883-MF for pgsql-docs@postgresql.org; Tue, 18 Jun 2013 03:15:22 +0000 Received: from mailout-de.gmx.net ([10.1.76.17]) by mrigmx.server.lan (mrigmx002) with ESMTP (Nemesis) id 0MLDZP-1UoVPD1e1h-000I8f for ; Tue, 18 Jun 2013 05:15:18 +0200 Received: (qmail invoked by alias); 18 Jun 2013 03:15:18 -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 (mp017) with SMTP; 18 Jun 2013 05:15:18 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+ircF23SuiQSGp1FGSJSZWqH6UKWLd6wI6BY89D0 c7WqUytB21kL0v Message-ID: <1371525315.13762.12.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: Mon, 17 Jun 2013 23:15:15 -0400 In-Reply-To: <18362.1368288613@sss.pgh.pa.us> References: <518C0B2B.9040909@falter.at> <18362.1368288613@sss.pgh.pa.us> 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.0 (---) 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 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. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs