Re: String reverse funtion? - Mailing list pgsql-general

2013/10/9 John Meyer <johnmeyer@pueblocomputing.com>

On 10/9/2013 11:52 AM, David Johnston wrote:

ginkgo36 wrote

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)

Regards

Pavel

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general