Re: [GENERAL] Pattern Matching question - PG 9.6

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Pattern Matching question - PG 9.6
Дата
Msg-id CAKFQuwaLMV3yL1jfK4s6q-gVnExGL8hjgTUcnjh-kTQE+y0oBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Pattern Matching question - PG 9.6  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
On Sunday, May 14, 2017, Patrick B <patrickbakerbr@gmail.com> wrote:

I thought I have already explained it. Here it goes again. Demo page is: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=ea61e7e1859bdb7f297f853a9dc0e3d0


Now that you've posted the right link it becomes a bit easier to follow...
 

To summarize: I wanna use a pattern matching the only returns these rows:

/testfile/client/10/attachment/1000/master/
/testfile/client/10/attachment/unassigned/file/1001/master
/testfile/client/10/attachment/unassigned/file/1002/master
Why isn't 7 valid?

Requiring that the last directory be the word master, with or without a forward slash, is simple enough but 7 matches that.  Just tack the following onto the end of your existing pattern.

.+master/?$

You'll need to be more verbose and literal if you truly want to exclude 7.  Just add more path separators and patterns like [^/]+ until you get what you want.

I'd be more helpful but my iPad and the fiddle don't seem to play nicely together...

David J.

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

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