PostgreSQL:用数组替换generate_series

Question

我有一个工作的SQL代码，它根据从generate_series函数生成的数字创建几何图形：

  CREATE TEMPORARY TABLE catchments ON COMMIT DROP AS (
    SELECT lims, ST_ConcaveHull(the_geom, alpha_factor) AS the_geom_overlap FROM (
      SELECT lims, ST_MakeValid(ST_Collect(n.the_geom)) AS the_geom
      FROM generate_series(1, 10, 2) AS lims, pgr_drivingDistance(
        'SELECT id, source, target, cost, reverse_cost FROM edges',
        vertex_id, lims, true
      ) a, nodes n WHERE a.node = n.vid
      GROUP BY lims
    ) AS conv_hull
    ORDER BY lims DESC
  );

现在我需要用一个可变间隔的数组来代替固定的区间序列，例如1，2，5，7，8。

是否有一种简单的方法可以通过具有相同逻辑的数组“转换”generate_series？如果可能的话，我想避免使用for循环。

Answer 1

FROM unnest(ARRAY[1,2,5,7,8]) AS lims

应该这么做。