Forum OpenACS Development: Response to Porting ACS 4 PL/Sql packages

Posted by Sebastian Skracic on
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.