Two functions exists that convert "text" to "text[]" regexp_string_to_array(text, text [,text]) : http://www.postgresql.org/docs/9.4/interactive/functions-string.html string_to_array(text, text [, text]) : http://www.postgresql.org/docs/9.4/interactive/functions-array.html
Would it be hateful to make it so that both entries appear on both tables? array_to_string(anyarray, text [,text]) could be lumped in with this as well. string_to_array not being on the string functions page is the more glaring omission for me. David J.