From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: mixed, named notation support |
Date: | 2009-07-25 18:21:13 |
Message-ID: | 162867790907251121h232de35agfecf2b2dfeed527f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
fixed patch attached + more regress tests.
Regards
Pavel Stehule
2009/7/23 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 2009/7/23 Bernd Helmle <mailings(at)oopsware(dot)de>:
>> --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?
>
> it is probably bug. I'll look on it tomorrow.
>
> Pavel
>
>>
>>
>> --
>> Thanks
>>
>> Bernd
>>
>
Attachment | Content-Type | Size |
---|---|---|
named-fixed.diff.gz | application/x-gzip | 12.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2009-07-25 19:12:40 | Re: Merge Append Patch merged up to 85devel |
Previous Message | Tom Lane | 2009-07-25 18:01:26 | Re: proposal: support empty string as separator for string_to_array |