I was lately writing some program for a client of mine, which used UPC codes matching.
Since the codes are given in various ways, there was decision to pad the codes with leading zeros – up to 12 characters.
The code has been done, and worked like this:
# SELECT lpad('123456789', 12, '0'); lpad -------------- 000123456789 (1 ROW)