PostgreSQL: Pattern matching with LIKE, SIMILAR TO or regular expressions

http://dba.stackexchange.com/questions/10694/pattern-matching-with-like-similar-to-or-regular-expressions-in-postgresql