postgresql7.3 SELECT p.process_id, p.one_line, p.description, p.party_id, to_char(p.creation_date,'YYYY-MM-DD') as creation_date_ansi, (select count(*) from pm_process_instance i where i.process_id = p.process_id) as instances, person__name(party_id) as owner_name FROM pm_process_active p ORDER BY p.one_line