Re: plpgsql: defuault parameters and constant function parameters

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