Changelog

New SQL function string_to_array

Apr 21, 2025

We’ve added support for a new SQL function string_to_array to our managed cloud.

string_to_array (docs) splits a string based on a delimiter and returns an array of the split elements.

sql

> SELECT string_to_array('new Materialize SQL function is here!', 'SQL');

Output:

              string_to_array              
-------------------------------------------
 {"new Materialize "," function is here!"}
(1 row)

Get Started with Materialize

Get hands-on with a Free Trial. Materialize can be run as a service or you can self-manage anywhere.