Re: Extracting hostname from URI column

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Extracting hostname from URI column
Дата
Msg-id 46E73D1C.4020009@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Extracting hostname from URI column  (chester c young <chestercyoung@yahoo.com>)
Ответы Re: Extracting hostname from URI column  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Re: Extracting hostname from URI column  (chester c young <chestercyoung@yahoo.com>)
Re: Extracting hostname from URI column  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Список pgsql-sql
chester c young wrote:
>> I'm trying to use substr() and position() functions to extract the
>> full host name (and later a domain) from a column that holds URLs.
> 
> substring( href from '.*://\([^/]*)' );
> 

Ok, your solution looks better than mine... but I have no idea how to 
interpret that, time to consult some manuals.

-- 
Paul Lambert
Database Administrator
AutoLedgers



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select sum within transaction problem
Следующее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: Extracting hostname from URI column