postgresql7.1
select site_node__new (
:new_node_id,
:parent_id,
:name,
NULL,
:directory_p,
:pattern_p,
:user_id,
:ip_address
)
select site_node__new (
null,
:parent_node_id,
:instance_name,
null,
't',
't',
null,
null
);
select site_node__url(node_id) from site_nodes where object_id=:subsite_pkg_id
select site_node__delete(:node_id);