BUG #2127: Regular Expression Limits Do Not Work

Поиск
Список
Период
Сортировка
От Kyril Alyoshin
Тема BUG #2127: Regular Expression Limits Do Not Work
Дата
Msg-id 20051225203549.3CF2AF0AC8@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2127: Regular Expression Limits Do Not Work  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2127
Logged by:          Kyril Alyoshin
Email address:      kyrill@technolog.ca
PostgreSQL version: 8.0.3
Operating system:   Windows XP
Description:        Regular Expression Limits Do Not Work
Details:

I am writing a regex to verify US zipcodes. The expression is very simple,
in a trigger function it looks like this:

IF (NEW.postal_code_name !~ '\\d{5}')
THEN
    RAISE EXCEPTION 'error';
END IF;

The bug description is:

If postal_code_name is > 5 digits, the expression would still evaluate to
false, and the error will not be raised.

Please correct this.

Thank you.

Kyrill

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

Предыдущее
От: "Guerra Antonio"
Дата:
Сообщение: BUG #2133: can't reinstall postgresql
Следующее
От: zhuge xiao
Дата:
Сообщение: Re: BUG #2118: could not connect to server