From: Bruce Momjian <bruce@momjian.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-interfaces@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Roger Moloney <ramoloney@hotmail.com>
Subject: Re: plpgsql: defuault parameters and constant function parameters
Date: Tue, 18 Sep 2007 18:11:47 -0400 (EDT)
Message-ID: <200709182211.l8IMBl527174@momjian.us> (raw)
In-Reply-To: <200709182325.12677.peter_e@gmx.net>
Peter Eisentraut wrote:
> Tom Lane wrote:
> > It's easier if the defaultable parameters are at the end, but I
> > rather wonder how your informix system is disambiguating the calls
> > either with a signature like that. ?If you leave off just one of the
> > two defaultable parameters, how does it know which?
>
> Several other SQL systems allow naming the parameters in calls, such as
>
> CALL foo(a = 1, b = 2)
>
> That's the only way to stay sane with function having 20 or more
> parameters anyway.
TODO has:
o Allow function parameters to be passed by name,
get_employee_salary(12345 AS emp_id, 2001 AS tax_year)
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
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-interfaces@postgresql.org
Cc: bruce@momjian.us, peter_e@gmx.net, tgl@sss.pgh.pa.us, ramoloney@hotmail.com
Subject: Re: plpgsql: defuault parameters and constant function parameters
In-Reply-To: <200709182211.l8IMBl527174@momjian.us>
* 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