Re: CALL and named parameters - Mailing list pgsql-general

From Tom Lane
Subject Re: CALL and named parameters
Date
Msg-id 1569525.1754577735@sss.pgh.pa.us
Whole thread Raw
In response to Re: CALL and named parameters  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Dominique Devienne <ddevienne@gmail.com> writes:
> But still, arg names are not part of the signature.
> So they should be checked after the fact.

No, that's not how it works.  David's comment about signature
reflects the fact that the primary key of pg_proc is name +
schema + input argument types.  Arg names are independent of
that and actually have to be checked before we consider argument
type matching, because they help determine which input argument
is which.

(There was considerable debate when we added output arguments
and argument names about whether pg_proc's primary key should
be extended.  We ended up not, but it was a judgment call.)

            regards, tom lane



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: CALL and named parameters
Next
From: Adrian Klaver
Date:
Subject: Re: Libpq.dll