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
|
| Список | 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 по дате отправления: