postgresql7.1 select content_item__set_release_period( :item_id, $start_when, $end_when ); select content_item__is_publishable( :item_id ) select content_item__is_published( :item_id ) select coalesce(publish_status, 'production') as publish_status, to_char(coalesce(start_when, current_timestamp), 'YYYY MM DD HH24 MI SS') as start_when, to_char(coalesce(end_when, current_timestamp + 365), 'YYYY MM DD HH24 MI SS') as end_when from cr_items i left outer join cr_release_periods r using (item_id) where i.item_id = :item_id