postgresql7.1 select item_id, revision_id, content_revision__get_number(:revision_id) as revision_no, publish_title, html_p, publish_date, archive_date, creation_ip, creation_date, publish_body, '' || item_creator || '' as creator_link from news_item_revisions where item_id = :item_id and revision_id = :revision_id