How can I trim a text array in mysql?
===

Is it possible to trim a text array in mysql? If so, how?

I want to get something like:

        select trim(myTextArrayColumn) from myTable;

where myTextArrayColumn is of type text[].

Example column values:

        {"someData1 ", "someData2 "}

        {" someData3 "}
