Re: Equivalent of Reverse() functions - Mailing list pgsql-sql

Kumar wrote:
> I am migrating an SQL Server 2000 database to Postgres 7.3.4 running
> on RH Linux 7.2. While migrating I encounter SQL Server REVERSE( )
> function, seems no such functions at Postgres.
> 
> Is there a equivalent function available at Postgres? Please shed
> some light

How about:

create or replace function reverse(text) returns text as ' return reverse($_[0]);
' language plperl;

regression=# select reverse('abcdef'); reverse
--------- fedcba
(1 row)

Joe