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

From ginkgo36
Subject Re: String reverse funtion?
Date
Msg-id 1381370002527-5773950.post@n5.nabble.com
Whole thread Raw
In response to Re: String reverse funtion?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: ERROR: invalid value "????" for "YYYY"
Next
From: John R Pierce
Date:
Subject: Re: [HACKERS] Urgent Help Required