postgresql7.1 select acs_object__name(:package_id) from dual select site_node__url(n.node_id) as url, acs_object__name(n.object_id) as name from site_nodes n where n.parent_id = :node_id and n.object_id is not null