Index: openacs-4/packages/acs-subsite/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/Attic/index-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/index-postgresql.xql 18 Apr 2001 21:36:49 -0000 1.1 @@ -0,0 +1,23 @@ +<?xml version="1.0"?> +<queryset> + <rdbms> + <type>postgresql</type> + <version>7.1</version> + </rdbms> + + <fullquery name="dbqd.acs-subsite.www.index.name"> + <querytext> + select acs_object__name(:package_id) + </querytext> + </fullquery> + + <fullquery name="dbqd.acs-subsite.www.index.site_nodes"> + <querytext> + 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 + </querytext> + </fullquery> + +</queryset>