Re: Extracting hostname from URI column

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: ogjunk-pgjedan(at)yahoo(dot)com
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Extracting hostname from URI column
Date: 2007-09-12 00:42:46
Message-ID: 335491.75226.qm@web54303.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-09-12 01:09:13 Re: select sum within transaction problem
Previous Message Paul Lambert 2007-09-12 00:22:52 Re: Extracting hostname from URI column