Re: mixed, named notation support

--On Donnerstag, März 05, 2009 08:41:28 +0100 Pavel Stehule
<pavel(dot)stehule(at)gmail(dot)com> 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