What does `STRING_TO_ARRAY(‘a,b,c’, ‘,’)` return in PostgreSQL?

Question

Advanced SQL Developer — Medium

What does `STRING_TO_ARRAY(‘a,b,c’, ‘,’)` return in PostgreSQL?

Accepted Answer

The function `STRING_TO_ARRAY('a,b,c', ',')` in PostgreSQL returns an array of strings containing 'a', 'b', and 'c' as elements. This is represented as ['a','b','c'] in the TEXT[] data type.