Index: openacs-4/packages/forums/sql/postgresql/forums-tree-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-tree-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/forums/sql/postgresql/forums-tree-create.sql 24 Jun 2002 22:37:52 -0000 1.4 +++ openacs-4/packages/forums/sql/postgresql/forums-tree-create.sql 25 Jun 2002 18:09:33 -0000 1.5 @@ -55,6 +55,9 @@ end if; -- generate the current sortkey + if v_parent_sortkey is null then + v_parent_sortkey := ''''; + end if; new.tree_sortkey := v_parent_sortkey || v_max_child_sortkey; return new;