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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org