Index: openacs-4/packages/bookmarks/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/www/index-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/bookmarks/www/index-postgresql.xql	17 Aug 2002 18:01:43 -0000	1.9
+++ openacs-4/packages/bookmarks/www/index-postgresql.xql	25 Sep 2003 17:06:02 -0000	1.10
@@ -95,6 +95,29 @@
         order by b.tree_sortkey
       </querytext>
 </fullquery>
+
+<fullquery name="bm_info">      
+      <querytext>
+
+        select   b.bookmark_id, 
+	         b.url_id, 
+                 b.local_title, 
+	         acs_objects.creation_date, 
+	         b.parent_id,
+                 bm_urls.complete_url, 
+	         b.folder_p
+        from     (select bm.bookmark_id, bm.url_id, bm.local_title, bm.folder_p, 
+		  bm.parent_id, bm.owner_id, bm.tree_sortkey from bm_bookmarks bm, bm_bookmarks bm2
+		  where bm2.bookmark_id = :root_folder_id
+                    and bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey)
+		 ) b left join bm_urls using (url_id),
+	         acs_objects
+        where    owner_id       = :user_id
+	and      acs_objects.object_id = b.bookmark_id
+	order by b.tree_sortkey
+    
+      </querytext>
+</fullquery>
  
 </queryset>