--On Donnerstag, März 05, 2009 08:41:28 +0100 Pavel Stehule
<pavel.stehule@gmail.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
