From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pattern Matching question - PG 9.6 |
Date: | 2017-05-15 04:10:01 |
Message-ID: | CAKFQuwbDQhkcPuSzgv3PdXbGd8a0NVp4DRtUiAp-Bv6+4NaOPA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sunday, May 14, 2017, Patrick B <patrickbakerbr(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick B | 2017-05-15 04:21:30 | Re: Pattern Matching question - PG 9.6 |
Previous Message | Patrick B | 2017-05-15 04:08:36 | Re: Pattern Matching question - PG 9.6 |