On 10/3/07, hubert depesz lubaczewski <depesz@depesz.com> wrote:
> On Wed, Oct 03, 2007 at 11:47:26AM -0400, Jerry Sievers wrote:
> > Question: Am I overlooking a simple way of doing this?
>
> yes. use plpython or plperl to do the job.
>
> depesz
>
here is a great example with pl/perl (search: printf)
http://people.planetpostgresql.org/greg/index.php?/categories/12-PlPerl
-- Parse a pipe-delimeted string:
SELECT sprintf('Total grams: %3.3f Donuts: %s',
'101.319472|chocolate and boston cream', '|');
sprintf
---------------------------------------------------------
Total grams: 101.319 Donuts: chocolate and boston cream
merlin
