Hello everyone I have to reverse a string like EA;BX;CA to CA;BX;EA. or EA,BX,CA to CA,BX,EA Is there any function to do this?
Thanks all!
No. You will have to write your own.
David J.
Based upon the example, it's probably very easy to use a split/explode in your language of choice (VB.NET, perl, python, etc).
or SQL
select string_agg(u, ';' order by r desc) from (select row_number() over () r, u from unnest(string_to_array('EA;BX;CA',';')) u) x; string_agg ──────────── CA;BX;EA (1 row)