«
»

get hostname from url as stored procedure in plpgsql


I just needed a simple stored procedure to extract the hostname from any given URL. So here is what I came up with.

CREATE OR REPLACE FUNCTION getHostFromUrl(p_url character varying)
  RETURNS character varying AS
$BODY$
declare
begin
  return substring(p_url from  'http.?://(.*?)/(.*)');
end;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

,

This entry was posted on Tuesday, June 9th, 2009 and is filed under Uncategorized. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

  1. #1 by Kelly Brown on June 12th, 2009

    I really like your post. Does it copyright protected?

    Quote

  2. #2 by jens on June 12th, 2009

    thanks,
    and use it however you want.

    Quote

  3. #3 by KonstantinMiller on July 6th, 2009

    Hello, can you please post some more information on this topic? I would like to read more.

    Quote
(will not be published)

  1. No trackbacks yet.