postgresql 7.1
delete from weblogger_ping_urls where package_id = :package_id
insert into weblogger_ping_urls ( package_id, ping_url ) values ( :package_id, :default_ping_url )

declare channel_rec record; entry_rec record; begin -- delete weblogger_channels for channel_rec in select channel_id from weblogger_channels where package_id = :package_id loop perform weblogger_channel__delete(channel_rec.channel_id); end loop;

-- delete weblog entries for entry_rec in select entry_id from pinds_blog_entries where package_id = :package_id loop perform pinds_blog_entry__delete(entry_rec.entry_id); end loop;

return 0; end;