Re: mixed, named notation support

--On Donnerstag, März 05, 2009 08:41:28 +0100 Pavel Stehule 
 wrote:

> Hello
>
> I did some cleaning on this feature, and I hope so I solve some Tom's
> objections
>
> features:
>  * PostgreSQL's specific syntax for named parameter: value AS name,
>  * Doesn't change rules for defaults,
>  * Get defaults for named, mixed notation in planner time.
>

Pavel, consider the following function:

CREATE OR REPLACE FUNCTION ftest(a int, b text)
RETURNS RECORD
LANGUAGE SQL
AS
$$       SELECT $1, $2 ;
$$;

#= SELECT ftest('blubb' AS b, 128 AS a);
ERROR:  function ftest(unknown, integer) does not exist at character 8

#= SELECT ftest(128 AS a, 'abcd' AS b);  ftest
------------(128,abcd)
(1 row)

Isn't the first one supposed to work?


--  Thanks
                   Bernd