Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Vitaly" <vitaly(dot)yakunin(at)gmail(dot)com>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
- Date: Thu, 29 Nov 2007 11:24:12 -0500
"Vitaly" <vitaly(dot)yakunin(at)gmail(dot)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
- References:
- Prev by Date: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
- Next by Date: BUG #3790: pg_restore error canceling statement due to user request
- Previous by thread: BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern
- Next by thread: BUG #3790: pg_restore error canceling statement due to user request
- Indexes: