Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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/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' variationand if it is unassigned (attachment/unassigned); then i want it tooThe rows that I should be getting are:5 /testfile/client/10/attachment/1000/master/ 107 /testfile/client/10/attachment/unassigned/file/1001/master 108 /testfile/client/10/attachment/unassigned/file/1002/master 10What am I doing wrong?ThanksPatrick.
SELECT * FROM test1 WHERE client_id = 10 AND path ~ '^/testfile/client/[0-9]+/attachment/(([0-9]{1,14})|(unassigned))/'
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?
ThanksPatrick.
Patrick.
В списке pgsql-general по дате отправления: