Re: [SQL] Reverse String in sql or pgplsql

[Bradley Miller]

create or replace function reverse_string(text) returns text as
'
DECLARE
reversed_string text;
incoming alias for $1;

BEGIN

reversed_string = '''';

for i in reverse char_length(incoming)..1 loop

reversed_string = reversed_string || substring(incoming from i for 1);

end loop;

return reversed_string;



END'
language plpgsql;

select * from reverse_string('Postgres');

reverse_string
sergtsoP


On Feb 26, 2005, at 11:55 AM, Oisin Glynn wrote:

Did some searching on forums archives to no avail, I found a  PL/Perl example but would like to do this in plpgsql if possible. Does somebody have this sitting around, I just dont want to reinvent the wheel.  But if need to I will.
 
Thanks in advance,
 
Oisin

Bradley Miller
<x-tad-bigger>NUVIO CORPORATION</x-tad-bigger><x-tad-bigger>
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
</x-tad-bigger><x-tad-bigger>http://www.nuvio.com</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]</x-tad-bigger>