-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 11 déc. 08 à 21:23, Tom Lane a écrit :
It's not that easy to produce a message that wouldn't be annoying
noise.
Something really amazing in PostgreSQL is the HINTs system in error
messages. Almost all the time thoses messages are focused and
Dimitri Fontaine writes:
>> The sanest answer I can see is "so, don't do that".
> Is there any warning level message at CREATE FUNCTION time for the
> user/dba to know he's doing something... border line, almost shooting
> himself in the foot?
It's not that easy to produce a message that wou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Le 11 déc. 08 à 16:22, Tom Lane a écrit :
Yeah, we already bit this bullet with variadic functions --- if you
have
myfunc(int, float)
myfunc(int, variadic float[])
then it's ambiguous which one should be used for call "myfunc(1
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> no, it's little bit different
> Default is only stored parameter value. You created two functions with
> two different signatures
> myfunc(int)
> myfunc(int, int)
Yeah, we already bit this bullet with variadic functions --- if you have
myfunc
On Thu, Dec 11, 2008 at 12:59 PM, Pavel Stehule <[EMAIL PROTECTED]>wrote:
> 2008/12/11 Rushabh Lathia <[EMAIL PROTECTED]>:
> >
> >
> > On Thu, Dec 11, 2008 at 12:40 PM, Pavel Stehule <[EMAIL PROTECTED]
> >
> > wrote:
> >>
> >> Hello
> >>
> >>
> >> when you created function, we cannot check default
2008/12/11 Rushabh Lathia <[EMAIL PROTECTED]>:
>
>
> On Thu, Dec 11, 2008 at 12:40 PM, Pavel Stehule <[EMAIL PROTECTED]>
> wrote:
>>
>> Hello
>>
>>
>> when you created function, we cannot check defaults, because we don't
>> know if anybody use default or not. And when you call function, then
>> pos
On Thu, Dec 11, 2008 at 12:40 PM, Pavel Stehule <[EMAIL PROTECTED]>wrote:
> Hello
>
> 2008/12/11 Rushabh Lathia <[EMAIL PROTECTED]>:
> > Hi,
> >
> > Testcase: (8.4 CVS head)
> >
> >
> > CREATE OR REPLACE FUNCTION myfunc(y int)
> > RETURNS INTEGER AS $$
> >select 100;
> >
Hello
2008/12/11 Rushabh Lathia <[EMAIL PROTECTED]>:
> Hi,
>
> Testcase: (8.4 CVS head)
>
>
> CREATE OR REPLACE FUNCTION myfunc(y int)
> RETURNS INTEGER AS $$
>select 100;
> $$ language sql;
>
> CREATE OR REPLACE FUNCTION myfunc(y int, x integer DEFAULT 100)
> RETURNS INT
On Thu, Dec 11, 2008 at 12:33 PM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Rushabh Lathia wrote:
>
>> Hi,
>>
>> Testcase: (8.4 CVS head)
>>
>>
>> CREATE OR REPLACE FUNCTION myfunc(y int)
>> RETURNS INTEGER AS $$
>> select 100;
>> $$ language sql;
>>
>> CREATE OR REPLAC
Rushabh Lathia wrote:
Hi,
Testcase: (8.4 CVS head)
CREATE OR REPLACE FUNCTION myfunc(y int)
RETURNS INTEGER AS $$
select 100;
$$ language sql;
CREATE OR REPLACE FUNCTION myfunc(y int, x integer DEFAULT 100)
RETURNS INTEGER AS $$
select 200;
$$ language sql;
select
Hi,
Testcase: (8.4 CVS head)
CREATE OR REPLACE FUNCTION myfunc(y int)
RETURNS INTEGER AS $$
select 100;
$$ language sql;
CREATE OR REPLACE FUNCTION myfunc(y int, x integer DEFAULT 100)
RETURNS INTEGER AS $$
select 200;
$$ language sql;
select myfunc(10);
myfunc
--
11 matches
Mail list logo
