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

Reply via email to