Re: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
Дата
Msg-id 14553.1196353452@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern  ("Vitaly" <vitaly.yakunin@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
"Vitaly" <vitaly.yakunin@gmail.com> writes:
> SELECT author, type
>   FROM books WHERE "type" ~ '(?!novel)';

> This select work incorrect. It returns all types.

Certainly.  That's a negative-lookahead pattern and is therefore
guaranteed to match somewhere in every string (at the end, if
nowhere else).

            regards, tom lane

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

Предыдущее
От: "Vitaly"
Дата:
Сообщение: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
Следующее
От: NikhilS
Дата:
Сообщение: Re: BUG #3774: create table like including index doesn't update pg_constraints with primary key