pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Erik Rijkers <er@xs4all.nl>
To: Erwin Brandstetter <brandstetter@falter.at>
Cc: pgsql-docs@postgresql.org
Subject: Re: Reference function arguments by name
Date: Sat, 11 May 2013 12:23:47 +0200
Message-ID: <e16ed4cad76a4cdaefdfc2d90c3c1e5b.squirrel@webmail.xs4all.nl> (raw)
In-Reply-To: <518C0B2B.9040909@falter.at>
References: <518C0B2B.9040909@falter.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>

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).

-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

Attachments:

sql-createfunction.diff (application/octet-stream, 597B) download --- doc/src/sgml/html/sql-createfunction.html.orig 2013-05-11 12:19:58.579326825 +0200 +++ doc/src/sgml/html/sql-createfunction.html 2013-05-11 12:20:51.510004436 +0200 @@ -389,7 +389,7 @@ ></DT ><DD ><P -> The name of an argument. Some languages (currently only PL/pgSQL) let +> The name of an argument. Some languages (currently only PL/pgSQL and SQL) let you use the name in the function body. For other languages the name of an input argument is just extra documentation, so far as the function itself is concerned; but you can use input argument names

view thread (8+ messages)  latest in thread

Message-ID: <e16ed4cad76a4cdaefdfc2d90c3c1e5b.squirrel@webmail.xs4all.nl>
Permalink:  ../e16ed4cad76a4cdaefdfc2d90c3c1e5b.squirrel@webmail.xs4all.nl/
Also on:    postgresql.org/message-id/e16ed4cad76a4cdaefdfc2d90c3c1e5b.squirrel@webmail.xs4all.nl

 ·  · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: er@xs4all.nl, brandstetter@falter.at
  Subject: Re: Reference function arguments by name
  In-Reply-To: <e16ed4cad76a4cdaefdfc2d90c3c1e5b.squirrel@webmail.xs4all.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox