OpenACS

oracle
committed
MAIN:oracle:20011005195659
on 05 Oct 01
changes
openacs-4/.../www/index-postgresql.xql (+23)
  1 <?xml version="1.0"?>
  2 <queryset>
  3     <rdbms>
  4       <type>postgresql</type>
  5       <version>7.1</version>
  6     </rdbms>
  7
  8   <fullquery name="dbqd.acs-subsite.www.index.name">
  9     <querytext>
  10     select acs_object__name(:package_id)
  11     </querytext>
  12   </fullquery>
  13
  14   <fullquery name="dbqd.acs-subsite.www.index.site_nodes">
  15     <querytext>
  16   select site_node__url(n.node_id) as url, acs_object__name(n.object_id) as name
  17     from site_nodes n
  18    where n.parent_id = :node_id
  19     and n.object_id is not null
  20     </querytext>
  21   </fullquery>
  22
  23 </queryset>