Postgres Pro
Downloads
Home   >   mailing lists

Re: Fast REVERSE() function? - Mailing list pgsql-hackers

From hubert depesz lubaczewski
Subject Re: Fast REVERSE() function?
Date
Msg-id 20080908160339.GA10410@depesz.com
Whole thread Raw
In response to Fast REVERSE() function?  (Chris Browne <cbbrowne@acm.org>)
List pgsql-hackers
Tree view 
On Mon, Sep 08, 2008 at 11:20:18AM -0400, Chris Browne wrote:
> I've got a case where I need to reverse strings, and find that, oddly
> enough, there isn't a C-based reverse() function.
> A search turns up pl/pgsql and SQL implementations:

just for completenes - there is also pl/perl and c versions freely
available:
http://www.depesz.com/index.php/2007/07/30/indexable-field-like-something/
(pl/perl)
http://blog.frosties.org/post/2007/08/28/Fonction-reverse-C-avec-PostgreSQL
(c)

Best regards,

depesz

-- 
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-hackers by date:

Previous
From: "Mario Weilguni"
Date:
Subject: Re: Fast REVERSE() function?
Next
From: "Pavel Stehule"
Date:
Subject: Re: Fast REVERSE() function?