Re: Extracting hostname from URI column

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Extracting hostname from URI column
Date: 2007-09-12 02:38:04
Message-ID: 46E7510C.1090807@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andrej Ricnik-Bay wrote:

> Plain regex.... The key are the parenthesis () ...
> basically it will omit ANYTHING + two slashes at the beginning
> of a string. Then it will match everything BUT a slash, and as
> much of that as possible since regex are greedy by default
> (hence the host name he was looking for) ... and everything
> AFTER a slash will be omitted.
>
>
>
> Cheers,
> Andrej
>
>
Thanks - that makes a bit more sense. I'm in the middle of reading
chapter 9.3.7 of the manual - POSIX Regular Expressions - which I'm
assuming is dealing with this, so it's looking clearer.

--
Paul Lambert
Database Administrator
AutoLedgers

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ogjunk-pgjedan 2007-09-12 03:16:15 Re: Extracting hostname from URI column
Previous Message Andrej Ricnik-Bay 2007-09-12 02:19:12 Re: Extracting hostname from URI column