Thanks alot everyone,
Actually, I just start learning about Programming language. So, each your
solution is a good suggestion for me to learning. Thanks so much.
Please help me one User-defined Functions to solves this when my data like
this:
EA;BX;CA
CA;EA
BX;EA
And when run UDFs, output is:
CA;BX;EA
EA;CA
EA;BX
One again, thanks so much
Pavel Stehule wrote
>> 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@
> )
>> To make changes to your subscription:
>> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>>
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/String-reverse-funtion-tp5773871p5773950.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
