Re: Extracting hostname from URI column

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Extracting hostname from URI column
Дата
Msg-id 46E7510C.1090807@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Extracting hostname from URI column  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Ответы Re: Extracting hostname from URI column  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-sql
Andrej Ricnik-Bay wrote:

> Plain regex.... The key are the parenthesis () ...
> basically it will omit ANYTHING + two slashes at the beginning
> of a string.  Then it will match everything BUT a slash, and as
> much of that as possible since regex are greedy by default
> (hence the host name he was looking for) ... and everything
> AFTER a slash will be omitted.
> 
> 
> 
> Cheers,
> Andrej
> 
> 
Thanks - that makes a bit more sense. I'm in the middle of reading 
chapter 9.3.7 of the manual - POSIX Regular Expressions - which I'm 
assuming is dealing with this, so it's looking clearer.

-- 
Paul Lambert
Database Administrator
AutoLedgers


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

Предыдущее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: Extracting hostname from URI column
Следующее
От: ogjunk-pgjedan@yahoo.com
Дата:
Сообщение: Re: Extracting hostname from URI column