Re: [SQL] Equivalent of Reverse() functions

[Joe Conway]

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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])