Обсуждение: string reverse fucntion?
I am using Postgresql 8.1.
I have to reverse a string like 'abc' to 'cba'.
Is there any function to do this?
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. -- Richard Huxton Archonet Ltd
On Tue, Feb 9, 2010 at 10:31 PM, Richard Huxton <dev@archonet.com> wrote:
Shoaib Mir
http://shoaibmir.wordpress.com/
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;
--
http://shoaibmir.wordpress.com/
2010/2/9 Shoaib Mir <shoaibmir@gmail.com>: > On Tue, Feb 9, 2010 at 10:31 PM, Richard Huxton <dev@archonet.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
Hello > > I think that Pavel's stuff is more interesting (and effective): > > http://pgfoundry.org/projects/pstcollection/ > sorry, it is in orafce package (in pstcollection could be too (in future)) http://pgfoundry.org/projects/orafce Regards Pavel Stehule > -- > Vincenzo Romano > NotOrAnd Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >