On Wed, May 25, 2011 at 12:45, Reuven M. Lerner <reuven@xxxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
