2010/2/9 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; 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general