Re: Extracting hostname from URI column - Mailing list pgsql-sql

From Paul Lambert
Subject Re: Extracting hostname from URI column
Date
Msg-id 46E73D1C.4020009@autoledgers.com.au
Whole thread Raw
In response to Re: Extracting hostname from URI column  (chester c young <chestercyoung@yahoo.com>)
Responses Re: Extracting hostname from URI column
Re: Extracting hostname from URI column
Re: Extracting hostname from URI column
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: select sum within transaction problem
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Extracting hostname from URI column