Re: Calling PL functions with named parameters

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Calling PL functions with named parameters
Date: 2004-08-13 22:05:16
Message-ID: 411D3B1C.8010809@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Fetter wrote:
> Dennis has pointed out that mixing the call-with-named-parameter
> interface with call-by-order-of-parameters one would cause confusion,
> and I think it would be OK to disallow this type mixing, so
>
> SELECT foo_func(name AS 'yet another name', 35);
>
> would be disallowed.

Python's equivalent syntax allows you to mix the two forms so long as
all the by-position parameters come first:

>>> def f(a,b,c,d):
... print a,b,c,d
...
>>> f(1,2,3,4)
1 2 3 4
>>> f(1,2,c=3,d=4)
1 2 3 4
>>> f(1,2,d=4,c=3)
1 2 3 4
>>> f(1,d=4,2,c=3)
SyntaxError: non-keyword arg after keyword arg

-O

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-13 22:22:25 Re: Calling PL functions with named parameters
Previous Message David Fetter 2004-08-13 21:41:48 Calling PL functions with named parameters