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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend