A useful function to turn the elements of a string into rows.

SELECT *
FROM split('1,2,3,4', ',') as x(id);

will return 4 rows with a single column named ID:

id
--
1 
2 
3 
4 

Back to the SQL Feature Comparison