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

From Paul Lambert
Subject Re: Extracting hostname from URI column
Date
Msg-id 46E7510C.1090807@autoledgers.com.au
Whole thread Raw
In response to Re: Extracting hostname from URI column  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Responses Re: Extracting hostname from URI column
List 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


pgsql-sql by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Extracting hostname from URI column
Next
From: ogjunk-pgjedan@yahoo.com
Date:
Subject: Re: Extracting hostname from URI column