Now when I'm somewhat more familiar with core ACS data model,
I agree that handling of default values, especially in combination
with Pl/Tcl is unnecessarily complicated thing.
So I would suggest that all arguments should be retained in Postgres
functions. We'll just have to make sure that all arguments are
specified while we are porting some Oracle function/procedure
invocation, with maybe two exceptions:
- How to pass NULL value to the function?
- I think it's worth the effort to overload function
definitions for some functions/procedures that accepts
2-3 arguments, with 1-2 of them being optional, for
example group_contains_p in groups-create.sql
and site_node.node_id in site-nodes-create.sql.
