Re: mixed, named notation support

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: mixed, named notation support
Дата
Msg-id 162867790907251121h232de35agfecf2b2dfeed527f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: mixed, named notation support  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: mixed, named notation support  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hello,

fixed patch attached + more regress tests.

Regards
Pavel Stehule


2009/7/23 Pavel Stehule <pavel.stehule@gmail.com>:
> 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
>>
>

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: proposal: support empty string as separator for string_to_array
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: Merge Append Patch merged up to 85devel