Re: [GENERAL] PostgreSQL SQL Tricks: faster urldecode

2013-09-20 Thread Marc Mamin
> Von: Merlin Moncure [mmonc...@gmail.com] > Gesendet: Freitag, 20. September 2013 17:43 > > > On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin wrote: > > Hi, > > here is a function which is about 8 x faster than the one described in the > > PostgreSQL SQL Tricks > > ( > > http://postgres.cz/wiki

Re: [GENERAL] PostgreSQL SQL Tricks: faster urldecode

2013-09-20 Thread Merlin Moncure
On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin wrote: > Hi, > here is a function which is about 8 x faster than the one described in the > PostgreSQL SQL Tricks > ( > http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code > ) > > The idea is to handle each encoded/not_enc

[GENERAL] PostgreSQL SQL Tricks: faster urldecode

2013-09-20 Thread Marc Mamin
Hi, here is a function which is about 8 x faster than the one described in the PostgreSQL SQL Tricks ( http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code ) The idea is to handle each encoded/not_encoded parts in bulk rather than spliting on each character. urldeco