> 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 '.*://\([^/]*)' ); ____________________________________________________________________________________ Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org