postgresql7.1 select content_item__get_path(item_id,null) as path, item_id from cr_items where item_id = ( select item_id from cr_revisions where revision_id = :revision_id)