Re: Calling PL functions with named parameters

Tom Lane wrote:
> David Fetter <david(at)fetter(dot)org> writes:
>
>>CREATE OR REPLACE FUNCTION foo_func(name TEXT, val INTEGER) AS ...
>
>
>>SELECT foo_func(val AS 23, name AS 'Name goes here');
>
>
> I don't think that syntax will work. You could possibly do it the other
> way round:
>
> SELECT foo_func(23 AS val, 'Name goes here' AS name);
>
> which would have some commonality with SELECT's column-labeling syntax
> but otherwise seems to have little to recommend it. Are there any other
> vendors supporting such things in SQL, and if so how do they do it?

MSSQL's syntax for calling named parameters is like this:

CREATE PROCEDURE SampleProcedure @EmployeeIDParam INT,
@MaxQuantity INT OUTPUT AS ...

DECLARE @MaxQtyVariable INT
EXEC @rc = SampleProcedure @EmployeeIDParam = 9,
@MaxQuantity = @MaxQtyVariable OUTPUT

This is commonly used if a parameter should be left default (and I don't
like it).

Regards,
Andreas