On Sunday, May 14, 2017, Patrick B <patrickbake...@gmail.com> wrote: > > Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle= > 3c3a3f870eb4d002c5b4200042b25669 > <http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=c2fbb7da5a2397f7cda5126ed239c080> > > The rows that I should be getting are: > > 5 /testfile/client/10/attachment/1000/master/ 10 > > 7 /testfile/client/10/attachment/unassigned/file/1001/master 10 > > 8 /testfile/client/10/attachment/unassigned/file/1002/master 10 > > What am I doing wrong? >
Without you explaining why 6 and 9 are invalid it's impossible to say how you should modify your regex to exclude them. You may find positive and negative look-ahead useful though. David J.
