Re: Speeding up loops in pl/pgsql function - Mailing list pgsql-performance

From Alex Hunsaker
Subject Re: Speeding up loops in pl/pgsql function
Date
Msg-id BANLkTin52zF59YU-CO7NQifjAw3WsQWFSg@mail.gmail.com
Whole thread Raw
In response to Re: Speeding up loops in pl/pgsql function  ("Reuven M. Lerner" <reuven@lerner.co.il>)
List pgsql-performance
On Wed, May 25, 2011 at 12:45, Reuven M. Lerner <reuven@lerner.co.il> wrote:
> Hi, Alex.  You wrote:

>> I think select E'\XXX' is what you are looking for (per the fine
>> manual:
>> http://www.postgresql.org/docs/current/static/datatype-binary.html)
>
> I didn't think that I could (easily) build a string like that from digits in
> a variable or a column, but I'll poke around and see if it can work.

Well, if you build '\XXX' you can call escape(..., 'escape') on it
like I did with the regex above.

pgsql-performance by date:

Previous
From: "Reuven M. Lerner"
Date:
Subject: Re: Speeding up loops in pl/pgsql function
Next
From: Pavel Stehule
Date:
Subject: Re: Speeding up loops in pl/pgsql function