Index: openacs-4/packages/lars-blogger/sql/postgresql/rss-register.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/rss-register.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/lars-blogger/sql/postgresql/rss-register.sql 19 Aug 2002 21:52:59 -0000 1.1 +++ openacs-4/packages/lars-blogger/sql/postgresql/rss-register.sql 30 Jan 2003 16:55:50 -0000 1.2 @@ -6,24 +6,45 @@ -- @cvs-id $Id$ -- -select acs_sc_impl__new( - 'RssGenerationSubscriber', -- impl_contract_name - 'pinds_blog_entries', -- impl_name - 'lars-blogger' -- impl_owner_name -); +create function inline_0() returns integer as ' +declare + impl_id integer; + v_foo integer; +begin + -- the notification type impl + impl_id := acs_sc_impl__new( + ''RssGenerationSubscriber'', -- impl_contract_name + ''pinds_blog_entries'', -- impl_name + ''lars-blogger'' -- impl_owner_name + ); -select acs_sc_impl_alias__new( - 'RssGenerationSubscriber', -- impl_contract_name - 'pinds_blog_entries', -- impl_name - 'datasource', -- impl_operation_name - 'lars_blog__rss_datasource', -- impl_alias - 'TCL' -- impl_pl -); + v_foo := acs_sc_impl_alias__new( + ''RssGenerationSubscriber'', -- impl_contract_name + ''pinds_blog_entries'', -- impl_name + ''datasource'', -- impl_operation_name + ''lars_blog__rss_datasource'', -- impl_alias + ''TCL'' -- impl_pl + ); -select acs_sc_impl_alias__new( - 'RssGenerationSubscriber', -- impl_contract_name - 'pinds_blog_entries', -- impl_name - 'lastUpdated', -- impl_operation_name - 'lars_blog__rss_lastUpdated', -- impl_alias - 'TCL' -- impl_pl -); + v_foo := acs_sc_impl_alias__new( + ''RssGenerationSubscriber'', -- impl_contract_name + ''pinds_blog_entries'', -- impl_name + ''lastUpdated'', -- impl_operation_name + ''lars_blog__rss_lastUpdated'', -- impl_alias + ''TCL'' -- impl_pl + ); + + PERFORM acs_sc_binding__new ( + ''RssGenerationSubscriber'', + ''pinds_blog_entries'' + ); + + return (0); +end; +' language 'plpgsql'; + +select inline_0(); +drop function inline_0(); + + +