Index: openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/sql/postgresql/Attic/general-comments-plsql-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql 12 May 2003 03:05:16 -0000 1.4 +++ openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-plsql-create.sql 28 May 2003 00:54:51 -0000 1.5 @@ -3,6 +3,19 @@ -- 2003-05-04 create functions general_comment__new( + integer, + integer, + integer, + integer, + integer, + varchar, + varchar, + varchar, + integer, + timestamp_tz, + varchar, + varchar, + boolean ) returns integer as ' declare p_comment_id alias for $1; @@ -17,8 +30,13 @@ p_creation_date alias for $10; p_creation_ip alias for $11; p_mime_type alias for $12; + p_is_live alias for $13; v_item_id cr_items.item_id%TYPE; begin +-- +-- do something with p_is_live DaveB +-- + v_item_id := select nextval(acs_object_id_seq); PERFORM content_item__new(