On Wed, May 25, 2011 at 12:45, Reuven M. Lerner <reuven(at)lerner(dot)co(dot)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.