Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	3 Apr 2001 05:01:31 -0000	1.9
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	3 Apr 2001 23:59:56 -0000	1.10
@@ -699,8 +699,7 @@
   get_id__parent_id := content_symlink__resolve(get_id__parent_id);
 
   LOOP
-    -- FIXME: this use of instr in oracle code seems incorrect.
-    -- end_pos := instr(v_item_path, ''/'', start_pos);
+
     end_pos := instr(v_item_path, ''/'', start_pos);
 
     if end_pos = 0 then
@@ -952,9 +951,9 @@
 
   -- if the folder has an index page
   if v_is_folder = ''t'' and v_index is not null then
-    v_path := content_item__get_path(content_symlink__resolve(v_index));
+    v_path := content_item__get_path(content_symlink__resolve(v_index),null);
   else
-    v_path := content_item__get_path(v_item_id);
+    v_path := content_item__get_path(v_item_id,null);
   end if;
 
   return v_path;
@@ -1598,7 +1597,8 @@
   v_revision_id                            cr_revisions.revision_id%TYPE;
   v_publish_date                           cr_revisions.publish_date%TYPE;
 begin
-  
+  -- FIXME: what is up with this? both selects are the same.
+
   if get_publish_date__is_live then
     select
 	publish_date into v_publish_date