Regular expressions syntax: is \ the escape character ?

Поиск
Список
Период
Сортировка
От Gabriel Fernandez
Тема Regular expressions syntax: is \ the escape character ?
Дата
Msg-id 38C00CD1.14DFE13A@unica.edu
обсуждение исходный текст
Ответы Re: [GENERAL] Regular expressions syntax: is \ the escape character ?  (Charles Tassell <ctassell@isn.net>)
Список pgsql-general
Hi,

I'm using regular expressions in 6.5.3 version but i cannot find the
character to escape special caracters as ?, $, ^.

I've tried with \ but it doesn't works.

Example: i want to find the row with the value 'fisica?' and i do:

select title from libros where title ~* 'fisica\?' ;

but i also obtain rows with values:  'fisicamente' or 'fisicas'

What am i doing wrong ?

Thanks in advance.

Gabi :-)


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

Предыдущее
От: "Abdelkrim WAHHABI"
Дата:
Сообщение: system crash
Следующее
От: Charles Tassell
Дата:
Сообщение: Re: [GENERAL] Illegal use of aggregates or non-group column in target list