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

From Pavel Stehule
Subject WIP: default values for function parameters
Date
Msg-id 162867790810260428p56d16352qa1ec5c4c5330f25c@mail.gmail.com
Whole thread Raw
Responses Re: WIP: default values for function parameters  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Hello

I have problem with sending patch, so I am send link
http://www.pgsql.cz/patches/defaults.diff.gz

Example:
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;
CREATE FUNCTION
postgres=# select fx();
ERROR:  function fx() does not exist
LINE 1: select fx();             ^
HINT:  No function matches the given name and argument types. You
might need to add explicit type casts.
postgres=# select fx(10);fx
----80
(1 row)

postgres=# select fx(10,11);fx
----61
(1 row)

postgres=# select fx(10,11,12);fx
----33
(1 row)

Know bugs:
blind ambiguous call detection

comments, ideas?

regards
Pavel Stehule


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: BufferAccessStrategy for bulk insert
Next
From: "Pavel Stehule"
Date:
Subject: WIP: default values for function parameters