Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 63B199F9655 for ; Tue, 18 Sep 2007 18:25:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 98672-09 for ; Tue, 18 Sep 2007 18:25:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id E1C6B9F9611 for ; Tue, 18 Sep 2007 18:25:17 -0300 (ADT) Received: (qmail invoked by alias); 18 Sep 2007 21:25:14 -0000 Received: from xdsl-87-78-208-15.netcologne.de (EHLO colt.pezone.net) [87.78.208.15] by mail.gmx.net (mp021) with SMTP; 18 Sep 2007 23:25:14 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/XyWM14ZLXlZTFd26U/UqnOqNLzaYFIxB0cvO9Hx LfeKOyLTDnHttP From: Peter Eisentraut To: pgsql-interfaces@postgresql.org Subject: Re: plpgsql: defuault parameters and constant function parameters Date: Tue, 18 Sep 2007 23:25:12 +0200 User-Agent: KMail/1.9.7 Cc: Tom Lane , "Roger Moloney" References: <13701.1188433163@sss.pgh.pa.us> In-Reply-To: <13701.1188433163@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200709182325.12677.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/3 X-Sequence-Number: 6625 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. -- Peter Eisentraut http://developer.postgresql.org/~petere/