February 10th, 2009 by depesz | Tags: , , , , , , , | 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 ...

SoftNum asked on irc: < SoftNum> does postgresql have a config option to automatically trim (both ' ' from blah) on string compares? So, can you? Of course there is no such option, but maybe there is a way to tell PostgreSQL to ...