[GENERAL] Pattern Matching question - PG 9.6

Поиск
Список
Период
Сортировка
От Patrick B
Тема [GENERAL] Pattern Matching question - PG 9.6
Дата
Msg-id CAJNY3itxKZQYsvTFsHGmCB+_T-Upb4rop5NXSDC_uOM8oBHR8g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Pattern Matching question - PG 9.6
Re: [GENERAL] Pattern Matching question - PG 9.6
Список pgsql-general
Дерево обсуждения
AS you can see above, when performing this query:
SELECT * FROM test1 WHERE client_id = 10 AND path ~ '^/testfile/client/[0-9]+/attachment/(([0-9]{1,14})|(unassigned))/'

I get 5 rows. But actually I only want/need 3 of them:

  • with the 'master' variation
  • and if it is unassigned (attachment/unassigned); then i want it too

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?

Thanks

Patrick.

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [GENERAL] Top posting....
Следующее
От: Patrick B
Дата:
Сообщение: Re: [GENERAL] Pattern Matching question - PG 9.6