I have a column which has comma separated values.

--------
items
--------
a, b
--------

I want to list them as separate rows like:

------
Items
_____
a
b
----

I can’t seem to find the syntax to do this.

For other datbases I see that we can use unnest, but I can’t seem to get it to work for monetDB, though they have unnest listed as a keyword they do not have any documentation (or I can’t find) on how to use it.

I have tried

      select unnest(items) from table

but I get foloowing: no such unary operator ‘unnest'(clob)

I think unnest needs an array but I couldn’t find any documentation to convert clob to array.

Any help is appreaciated