Posts Tagged ‘domain’

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 -

MySQL’s timestamp in PostgreSQL

2008-05-08 17:16:43 CEST | 6 Comments | Tags: , , , , , ,

MySQL has this nifty/annoying feature/bug of special data type “TIMESTAMP”. It is like a DATETIME, but it gets automatically updated whenever you modify the row.

I’ll try to add the same feature to PostgreSQL.

- MORE -