Index: openacs-4/packages/categories/sql/postgresql/category-package.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-package.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/categories/sql/postgresql/category-package.sql 30 Mar 2013 22:50:44 -0000 1.8 +++ openacs-4/packages/categories/sql/postgresql/category-package.sql 7 Aug 2017 23:48:05 -0000 1.9 @@ -20,7 +20,7 @@ p_name varchar, p_description varchar, p_parent_id integer, - p_deprecated_p char, + p_deprecated_p boolean, p_creation_date timestamp with time zone, p_creation_user integer, p_creation_ip varchar @@ -137,7 +137,7 @@ DECLARE BEGIN update categories - set deprecated_p = 't' + set deprecated_p = true where category_id = p_category_id; return 0; @@ -159,7 +159,7 @@ DECLARE BEGIN update categories - set deprecated_p = 'f' + set deprecated_p = false where category_id = p_category_id; return 0;