Re: mixed, named notation support

2009/7/23 Bernd Helmle <mailings@oopsware.de>:
> --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?

it is probably bug. I'll look on it tomorrow.

Pavel

>
>
> --
>  Thanks
>
>                   Bernd
>