postgresql7.1
select na_source__new (
:source_id,
:package_id,
:owner_id,
:feed_url,
:link,
:title,
:description,
'0',
now(),
:last_modified,
'na_source',
:owner_id,
:creation_ip
)
select na_item__new (
:source_id,
:link,
:title,
:description,
now(),
'0'
);
select na_item__new (
:source_id,
:link,
:title,
:description,
now(),
'0'
);
delete from na_items where date + interval '2 month' < now()
update na_sources
set link = :link,
title = :title,
description = :description,
updates = (updates + 1),
last_scanned = now(),
last_modified = :last_modified
where source_id = :source_id