Index: openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql	31 Oct 2001 04:44:12 -0000	1.2
@@ -10,4 +10,24 @@
 </querytext>
 </fullquery>
 
+<fullquery name="get_item_id">
+<querytext>
+  select item_id
+    from cr_items
+   where parent_id = etp__get_folder_id(:package_id)
+     and name = :name
+</querytext>
+</fullquery>
+ 
+<fullquery name="get_revision_count">
+<querytext>
+    select count(1) as revision_count
+    from cr_revisions r, cr_items i
+    where r.item_id = i.item_id
+    and i.parent_id = etp__get_folder_id(:package_id)
+    and i.name = :name
+    and r.revision_id > :revision_id
+</querytext>
+</fullquery>
+
 </queryset>