CREATE OR REPLACE FUNCTION get_people()
      RETURNS person[]  LANGUAGE sql AS

person is a composite type, defined further up. The square brackets indicate an array of that type.