Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #2127: Regular Expression Limits Do Not Work
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Kyril Alyoshin" <kyrill(at)technolog(dot)ca>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #2127: Regular Expression Limits Do Not Work
- Date: Tue, 27 Dec 2005 10:22:28 -0500
- Message-id: <23077.1135696948@sss.pgh.pa.us> <text/plain>
"Kyril Alyoshin" <kyrill(at)technolog(dot)ca> writes:
> IF (NEW.postal_code_name !~ '\\d{5}')
> 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.
Please learn how to use regular expressions ;-)
You probably want '^\\d{5}$' instead, to require the regex to match the
whole string instead of just any part of it.
regards, tom lane
- References:
- BUG #2127: Regular Expression Limits Do Not Work
- From: Kyril Alyoshin
- BUG #2127: Regular Expression Limits Do Not Work
- Prev by Date: Re: BUG #2102: Backend reports wrong number of affected rows for a
- Next by Date: Re: BUG #2126: Index usage for function value
- Previous by thread: BUG #2127: Regular Expression Limits Do Not Work
- Next by thread: BUG #2128: unable to install win32 version of pgsql 8.1.1
- Indexes: