postgresql7.1 select content_item__get_id(:path, content_template__get_root_folder(), 'f') select content_template__get_root_folder() select content_item__get_path(:id, null) select t.template_id, i.name, to_char(o.last_modified, 'MM/DD/YY HH:MI AM') as modified, coalesce(round(r.content_length::float8 / 1000,2), 0)::float8::text || ' KB'::text as file_size from cr_templates t, acs_objects o, cr_revisions r RIGHT OUTER JOIN cr_items i ON i.latest_revision = r.revision_id where i.parent_id = :id and i.item_id = t.template_id and i.item_id = o.object_id order by upper(i.name)