Re: Help with a not match

"David G. Johnston" <[email protected]> Fri, 9 Nov 2018 11:17:04 -0700

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<CAKFQuwYbtcRfUy4iSOUqaJtnDOnAJ4vFW+wzrMgvev_r8yD-jg@mail.gmail.com>

On Fri, Nov 9, 2018 at 10:59 AM Campbell, Lance <[email protected]> wrote:

> SELECT regexp_matches(content, '/(?!files/'||id||'/)(files/\d+/)/', 'g') FROM tablea
> I get no matches.  My guess is I am close but slightly off on the syntax.

You have two forward slashes in a row at the end of the pattern:

( # capture
files/\d+/ #pattern, digits followed by slash, lead by files/
) # close capture
/ # another bracket - unlike Perl the // are not syntax but pattern

David J.