February 10th, 2009 by depesz | Tags: gotcha, length, lpad, postgresql, repeat, rpad, trim, truncate | 4 comments »
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 ...
