Postgres Pro
Downloads
Home   >   mailing lists

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

From chester c young
Subject Re: Extracting hostname from URI column
Date
Msg-id 335491.75226.qm@web54303.mail.re2.yahoo.com
Whole thread Raw
In response to Extracting hostname from URI column  (ogjunk-pgjedan@yahoo.com)
Responses Re: Extracting hostname from URI column
List pgsql-sql
Tree view 
> 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/

pgsql-sql by date:

Previous
From: ogjunk-pgjedan@yahoo.com
Date:
Subject: Extracting hostname from URI column
Next
From: Paul Lambert
Date:
Subject: Re: Extracting hostname from URI column