Re: string reverse fucntion?

[Shoaib Mir <shoaibmir@xxxxxxxxx>]

On Tue, Feb 9, 2010 at 10:31 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:

On 09/02/10 09:51, AI Rumman wrote:

I am using Postgresql 8.1.

I have to reverse a string like 'abc' to 'cba'.

Is there any function to do this?

Nothing built-in, but you can write your own easily enough in plpgsql - google a bit for examples.

From an old posting:

CREATE FUNCTION reverse(text) RETURNS text
    AS $_$
DECLARE
original alias for $1;
      reverse_str text;
      i int4;
BEGIN
    reverse_str := '';
    FOR i IN REVERSE LENGTH(original)..1 LOOP
      reverse_str := reverse_str || substr(original,i,1);
    END LOOP;
RETURN reverse_str;
END;$_$
    LANGUAGE plpgsql IMMUTABLE;

-- 

Shoaib Mir
http://shoaibmir.wordpress.com/