postgresql7.1 select r.subscr_id, r.timeout, r.summary_context_id, i.impl_name, case when r.lastbuild = null then 0 else date_part('epoch',r.lastbuild) end as lastbuild from rss_gen_subscrs r, acs_sc_impls i where i.impl_id = r.impl_id and (r.lastbuild is null or now() - r.lastbuild > cast(r.timeout || ' seconds' as interval)) update rss_gen_subscrs set lastbuild = now(), last_ttb = :last_ttb $extra_sql where subscr_id = :subscr_id select acs_sc_contract__get_id('RssGenerationSubscriber') select impl_id from acs_sc_impls i where impl_contract_name = 'RssGenerationSubscriber' and not exists (select 1 from acs_sc_bindings b where b.impl_id = i.impl_id and b.contract_id = :contract_id) select acs_sc_binding__new($contract_id,$impl_id)