Message-ID: <4DDD4E57.7070800@lerner.co.il>
Date: Wed, 25 May 2011 21:45:43 +0300
From: "Reuven M. Lerner" <reuven@lerner.co.il>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
To: Alex Hunsaker <badalex@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Speeding up loops in pl/pgsql function
References: <4DDD358E.20307@lerner.co.il>
	<BANLkTinuiR=Txtn_dUeSbvvgcWZj9c2+iw@mail.gmail.com>
In-Reply-To: <BANLkTinuiR=Txtn_dUeSbvvgcWZj9c2+iw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi, Alex.  You wrote:
> Have you tried something like:
> SELECT  encode(regexp_replace('141142143', '(\d{3})', '\\\1',
> 'g')::bytea, 'escape');
Hmm, forgot about regexp_replace.  It might do the trick, but without a 
full-blown eval that I can run on the replacement side, it'll be a bit 
more challenging.  But that's a good direction to consider, for sure.

> 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.

Thanks,

Reuven


-- 
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner