Forum OpenACS Development: site_node.get_tree_sortkey missing in acs-kernel (Oracle)

Posted by Michael Cordova on 03/17/10 04:51 PM

I have found today that site_node.get_tree_sortkey function is missing in site-nodes-create.sql for Oracle.

In fact, the create table site_nodes also miss the tree_sortkey field.

Should this be included for next release? If so, I think I can make the upgrade, and fix the create sql procs.

Posted by Dave Bauer on 03/17/10 04:59 PM

This function should not be needed on Oracle as it supported hierarchal queries natively using Connect By.