Index: openacs-4/packages/bm-portlet/sql/postgresql/bm-portlet-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bm-portlet/sql/postgresql/bm-portlet-drop.sql,v diff -u -r1.2 -r1.2.22.1 --- openacs-4/packages/bm-portlet/sql/postgresql/bm-portlet-drop.sql 9 Aug 2002 18:39:30 -0000 1.2 +++ openacs-4/packages/bm-portlet/sql/postgresql/bm-portlet-drop.sql 18 Aug 2014 20:49:33 -0000 1.2.22.1 @@ -26,18 +26,24 @@ -- 11th 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 select datasource_id into ds_id from portal_datasources - where name = ''bm_portlet''; + where name = 'bm_portlet'; if not found then - raise notice ''No datasource_id found here '', ds_id ; + raise notice 'No datasource_id found here ', ds_id ; ds_id := null; end if; @@ -48,7 +54,8 @@ return 0; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0 ();