Escaping parenthesis in regular expressions....

Поиск
Список
Период
Сортировка
От Steve Wolfe
Тема Escaping parenthesis in regular expressions....
Дата
Msg-id 00af01bfedbd$77fe0040$85755ad1@iboats.com
обсуждение исходный текст
Ответ на Solved Problem for Postmaster  ("Sean Alphonse" <salphonse1@home.com>)
Ответы Re: Escaping parenthesis in regular expressions....  (Charles Tassell <ctassell@isn.net>)
Re: Escaping parenthesis in regular expressions....  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Sean Alphonse"
Дата:
Сообщение: Solved Problem for Postmaster
Следующее
От: Yves Dorfsman
Дата:
Сообщение: Re: Postgresql and Postmaster response