Escaping parenthesis in regular expressions.... - Mailing list pgsql-general

  How does one escape parenthesis in a regular expression in Postgres?

  An example is:

select * from subcategories where subcategory ~* '401(k)';

Which does not work.  I've tried:

select * from subcategories where subcategory ~* '401\(k\)';

That still didn't work.  Any advice would be much appreciated.  BTW,

select * from subcategories where subcategory  =  '401(k)';

does work. ; )

steve