Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-15 Thread matshyeq
^/testfile/client/[0-9]+/attachment/([0-9]{1,14}/master/$|unassigned/) Kind Regards ~Maciek On 15 May 2017 at 06:21, Patrick B wrote: > > > 2017-05-15 16:10 GMT+12:00 David G. Johnston : > >> On Sunday, May 14, 2017, Patrick B wrote: >> >>> >>> Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddl

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-14 Thread David G. Johnston
On Sunday, May 14, 2017, Patrick B wrote: > > I thought I have already explained it. Here it goes again. Demo page is: > http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=ea61e7e1859bdb > 7f297f853a9dc0e3d0 > > Now that you've posted the right link it becomes a bit easier to follow... > > To summar

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-14 Thread Patrick B
2017-05-15 16:10 GMT+12:00 David G. Johnston : > On Sunday, May 14, 2017, Patrick B wrote: > >> >> Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=3c3a3f870eb4d0 >> 02c5b4200042b25669 >> >> >> The rows that I sho

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-14 Thread David G. Johnston
On Sunday, May 14, 2017, Patrick B wrote: > > Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle= > 3c3a3f870eb4d002c5b4200042b25669 > > > The rows that I should be getting are: > > 5 /testfile/client/10/attachmen

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-14 Thread Patrick B
2017-05-15 15:20 GMT+12:00 Patrick B : > Hi guys, > > Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle= > 3c3a3f870eb4d002c5b4200042b25669 > > > FYI - NEW LINK http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=ea61e7e1

[GENERAL] Pattern Matching question - PG 9.6

2017-05-14 Thread Patrick B
Hi guys, Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=3c3a3f870eb4d002c5b4200042b25669 AS you can see above, when performing this query: > SELECT * FROM test1 WHERE client_id = 10 AND path ~ > '^/testfile/cl