postgresql7.1 select r.revision_id as object_id, r.title as title, '$path_stub' || r.content as content, 'text/html' as mime, '' as keywords, 'file' as storage_type from cr_revisions r where revision_id = :object_id select r.content as url from cr_revisions r where revision_id = :object_id