Index: openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql,v
diff -u -r1.17.2.1 -r1.17.2.2
--- openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	12 Dec 2002 01:32:48 -0000	1.17.2.1
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	12 Dec 2002 22:02:01 -0000	1.17.2.2
@@ -159,4 +159,25 @@
 </fullquery>
 
 
+<fullquery name="sp_get_page_id.page_and_package_ids">
+<querytext>
+select sp.static_page_id, f.package_id
+from static_pages sp, sp_folders f
+where sp.filename = :filename
+and sp.folder_id = f.folder_id
+-- Only want pages from the Static Pages package.
+and f.package_id in (
+  select package_id  from apm_packages
+  where package_key = :package_key )
+-- If the same page is in more than one instance of
+-- Static Pages for some reason, we only want one of
+-- them, and we don't care which.
+-- Oracle
+--and rownum <= 1
+-- PostgreSQL
+limit 1
+</querytext>
+</fullquery>
+
+
 </queryset>