Posts Tagged ‘trim’

Text comparisons that does automatic trim()

2008-10-15 22:04:20 CEST | 5 Comments | Tags: , , , ,

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 do this trim for given field? Sure there is :)

- MORE -