padding an integer ... - Mailing list pgsql-sql

From Marc G. Fournier
Subject padding an integer ...
Date
Msg-id 20051026005530.E993@ganymede.hub.org
Whole thread Raw
Responses Re: padding an integer ...  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Is there any way of "padding" an integer, similar to how, in perl, I would 
do:

printf("%03d", 1);

to get:

001

Specifically, I'm looking to do this in a pl/pgsql function ... like to 
avoid moving to pl/php or pl/perl if I can ... but, from what I've been 
able to find, I suspect I'm not going to have much of a choice ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: broken join optimization? (8.0)
Next
From: "Marc G. Fournier"
Date:
Subject: pl/* overhead ...