Re: WIP: default values for function parameters - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: WIP: default values for function parameters
Date
Msg-id 162867790810270948q7ce45f35w7d74b78169208b86@mail.gmail.com
Whole thread Raw
In response to Re: WIP: default values for function parameters  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
2008/10/27 Alvaro Herrera <alvherre@commandprompt.com>:
> Pavel Stehule escribió:
>
>> postgres=# create function fx(a int, b int default 30, c int default 40)
>> postgres-# returns int as $$ select $1 + $2 + $3; $$
>> postgres-# language sql;
>
> How do you deal with the case where you have
> f(a int, b int default 1) and
> f(a int, b text default '1')  ?
>
> select f(1);    -- which one do you call?

it should raise exception  - but actually it's undefined (I have known
bug in WIP patch).

regards
Pavel


> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: array_agg and array_accum (patch)
Next
From: Emmanuel Cecchet
Date:
Subject: Re: Hot Standby utility and administrator functions