Index: openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql 9 Aug 2002 18:39:31 -0000 1.2 +++ openacs-4/packages/faq-portlet/sql/postgresql/faq-admin-portlet-create.sql 27 Oct 2014 16:41:30 -0000 1.3 @@ -27,72 +27,79 @@ -- 10th July 2002 -- -create function inline_0 () -returns integer as ' -declare + + +-- +-- procedure inline_0/0 +-- +CREATE OR REPLACE FUNCTION inline_0( + +) RETURNS integer AS $$ +DECLARE ds_id portal_datasources.datasource_id%TYPE; -begin +BEGIN ds_id = portal_datasource__new( - ''faq_admin_portlet'', - ''Displays a FAQ'' + 'faq_admin_portlet', + 'Displays a FAQ' ); -RAISE NOTICE '' created new ds''; +RAISE NOTICE ' created new ds'; perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''t'', - ''shadeable_p'', - ''f'' + 't', + 't', + 'shadeable_p', + 'f' ); -RAISE NOTICE '' set shadeable''; +RAISE NOTICE ' set shadeable'; perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''t'', - ''hideable_p'', - ''f'' + 't', + 't', + 'hideable_p', + 'f' ); -RAISE NOTICE '' set hideable''; +RAISE NOTICE ' set hideable'; perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''t'', - ''user_editable_p'', - ''f'' + 't', + 't', + 'user_editable_p', + 'f' ); perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''t'', - ''shaded_p'', - ''f'' + 't', + 't', + 'shaded_p', + 'f' ); perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''t'', - ''link_hideable_p'', - ''t'' + 't', + 't', + 'link_hideable_p', + 't' ); perform portal_datasource__set_def_param ( ds_id, - ''t'', - ''f'', - ''package_id'', - '' '' + 't', + 'f', + 'package_id', + ' ' ); return 0; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql;