CREATE AGGREGATE array_accum (anyelement)
(
    sfunc = array_append,
    stype = anyarray,
    initcond = '{}'
);

SELECT id,nombre FROM rutas_servicio WHERE ARRAY[1,2] <@ (SELECT array_accum(idpais ) FROM puertos_pais);