Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 26 Jun 2001 01:29:16 -0000 1.8 +++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 13 Jul 2001 00:43:36 -0000 1.9 @@ -511,7 +511,7 @@ v_count integer; BEGIN - select (case when count(*) = 0 then ''f'' else ''t'' end) into + select (case when count(*) = 0 then FALSE else TRUE end) into v_return_value from bm_in_closed_p bic right join @@ -527,7 +527,7 @@ order by tree_sortkey ) bm on (bm.bookmark_id = bic.bookmark_id) - and bic.closed_p = ''t'' + where bic.closed_p = TRUE and bic.in_closed_p_id = p_user_id; return v_return_value; END;