Andrew Dunstan <and...@dunslane.net> writes: > On 5/5/21 2:45 PM, Tom Lane wrote: >> Yeah, that's because of the conversion to "chr". But a regexp >> is overkill for that anyway. Don't we have something that will >> split on simple substring matches?
> Not that I know of. There is split_part but I don't think that's fit for > purpose here. Do we need one, or have I missed something? [ checks manual ... ] string_to_array or string_to_table would do, I think. regards, tom lane