Re: Extracting hostname from URI column

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