Forum OpenACS Development: Response to Porting ACS 4 PL/Sql packages
17: Response to Porting ACS 4 PL/Sql packages (response to 1)
Posted by Sebastian Skracic on 11/09/00 09:39 AM
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.