The SQL standard defines the UNNEST function to return a result table with one row for each element of an array.

SELECT *
FROM UNNEST (array[1,2,3,4]) as x(id);

will return 4 rows with a single column named ID

Back to the SQL Feature Comparison