Re: Regex help again (sorry, I am bad at these)

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Regex help again (sorry, I am bad at these)
Дата
Msg-id 20151229205106.GC1812@elch.exwg.net
обсуждение исходный текст
Ответ на Re: Regex help again (sorry, I am bad at these)  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
## Melvin Davidson (melvin6925@gmail.com):

> UPDATE pcilms_assign
>    SET intro = REPLACE (intro, 'HVACR1114_LAB_13A.pdf',
> '&file=HVACR1114_LAB_13A.pdf')
>  WHERE intro like 'https://owncloud.porterchester.edu%'
>         AND course=18 and id=55413;

Unfortunately, that tries to do the right thing for that example
only but does not account for the 200k documents not named
HVACR1114_LAB_13A.pdf.

> NOTE: DO NOT use % in front of 'https: <https://owncloud.porterchester.edu>
> It is not needed and will slow query performance.

And that will plainly not work if the string does not start with the
URL - as in the example given.
It even won't work regardless of version and OS.

Regards,
Christoph

--
Spare Space


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

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Regex help again (sorry, I am bad at these)
Следующее
От: David Rowley
Дата:
Сообщение: Re: grep -f keyword data query