Re: regex (not) matching null string

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: regex (not) matching null string
Дата
Msg-id 20020621115533.N293-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на regex (not) matching null string  ("David M. Kaplan" <dmkaplan@ucdavis.edu>)
Список pgsql-bugs
On Wed, 19 Jun 2002, David M. Kaplan wrote:

> I have found that !~ and !~* do not match the null string even when one
> would expect them to.  I am not sure if this is how it is supposed to
> work or if this is an error.  If this is how it works, I can't figure
> out where it is states in the documentation.

I think it's probably working correctly.  NULL is an unknown value,
you can't necessarily know whether or not it'll match the pattern so
you should get an unknown back in both cases since NOT unknown is
itself unknown.

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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: regex (not) matching null string