Re: string reverse fucntion?

2010/2/9 Shoaib Mir <shoaibmir(at)gmail(dot)com>:
> On Tue, Feb 9, 2010 at 10:31 PM, Richard Huxton <dev(at)archonet(dot)com> 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;

I think that Pavel's stuff is more interesting (and effective):

http://pgfoundry.org/projects/pstcollection/

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS