Re: Is this really really as designed or defined in some standard - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Is this really really as designed or defined in some standard
Date
Msg-id 162867790809010215r5abd686bj6fc1ad7e6c0ae6b1@mail.gmail.com
Whole thread Raw
In response to Re: Is this really really as designed or defined in some standard  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Is this really really as designed or defined in some standard  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
2008/9/1 Magnus Hagander <magnus@hagander.net>:
> Pavel Stehule wrote:
>> Hello
>>
>> 2008/8/31 Hannu Krosing <hannu@2ndquadrant.com>:
>>> It seems that we allow several function arguments to have same
>>> name (or is it label :)
>>>
>>> hannu=# create or replace function ff(a int, a int) returns int language
>>> plpgsql as $$begin return $1+$2; end;$$;
>>> CREATE FUNCTION
>>> hannu=# select ff(1,1);
>>>  ff
>>> ----
>>>  2
>>> (1 row)
>>>
>>> hannu=# select ff(1,2);
>>>  ff
>>> ----
>>>  3
>>> (1 row)
>>>
>>> hannu=# create or replace function ffa(a int, a int) returns int
>>> language plpgsql as $$begin return a + a; end;$$;
>>> CREATE FUNCTION
>>> hannu=# select ffa(1,2);
>>>  ffa
>>> -----
>>>   2
>>> (1 row)
>>>
>>> Is this defined by some standard or just an oversight ?
>>>
>>
>> what is problem? You have two diferent functions. I don't see anything wrong.
>
> Take a look at the second function again. It's certainly not behaviour
> that I would expect :-) (I would expect a syntax error)

I see it now - it's really bug

Pavel

>
> //Magnus
>


pgsql-hackers by date:

Previous
From: "Radek Strnad"
Date:
Subject: Re: WIP patch: Collation support
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Auto-explain patch