pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedExtracting hostname from URI column
17+ messages / 8 participants
[nested] [flat]
* Extracting hostname from URI column
@ 2007-09-12 00:06 ogjunk-pgjedan@yahoo.com
0 siblings, 2 replies; 17+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2007-09-12 00:06 UTC (permalink / raw)
To: pgsql-sql
Hi,
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.
This is what I'm trying, but it clearly doesn't do the job.
=> select substr(href, position('://' in href)+3, position('://' in href)+3+position('/' in href)), href from url where id <10;
substr | href
----------------+----------------------------------------------------------
texturizer.net | http://texturizer.net/firebird/extensions/
texturizer.net | http://texturizer.net/firebird/themes/
forums.mozilla | http://forums.mozillazine.org/index.php?c=4
www.mozillazin | http://www.mozillazine.org/
devedge.netsca | http://devedge.netscape.com/viewsource/2002/bookmarks/
www.google.com | http://www.google.com/search?&q=%s
groups.google. | http://groups.google.com/groups?scoring=d&q=%s
www.google.com | http://www.google.com/search?q=%s&btnI=I'm+Feeling+Lucky
dictionary.ref | http://dictionary.reference.com/search?q=%s
The 3rd param to the substr function is clearly wrong. Is it even doable without writing a procedure?
Finally, is this the fastest way to get this data, or is there regex-based function that might be faster?
Thanks,
Otis
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 00:22 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: ogjunk-pgjedan@yahoo.com
1 sibling, 0 replies; 17+ messages in thread
From: Paul Lambert @ 2007-09-12 00:22 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; pgsql-sql
ogjunk-pgjedan@yahoo.com wrote:
> Hi,
>
> 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.
> This is what I'm trying, but it clearly doesn't do the job.
>
> => select substr(href, position('://' in href)+3, position('://' in href)+3+position('/' in href)), href from url where id <10;
> substr | href
> ----------------+----------------------------------------------------------
> texturizer.net | http://texturizer.net/firebird/extensions/
> texturizer.net | http://texturizer.net/firebird/themes/
> forums.mozilla | http://forums.mozillazine.org/index.php?c=4
> www.mozillazin | http://www.mozillazine.org/
> devedge.netsca | http://devedge.netscape.com/viewsource/2002/bookmarks/
> www.google.com | http://www.google.com/search?&q=%s
> groups.google. | http://groups.google.com/groups?scoring=d&q=%s
> www.google.com | http://www.google.com/search?q=%s&btnI=I'm+Feeling+Lucky
> dictionary.ref | http://dictionary.reference.com/search?q=%s
>
> The 3rd param to the substr function is clearly wrong. Is it even doable without writing a procedure?
>
> Finally, is this the fastest way to get this data, or is there regex-based function that might be faster?
>
> Thanks,
> Otis
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
Try this:
test=# select substr(href, position('://' in href)+3, position('/' in
substr(
href,position('://' in href)+3))-1), href from url;
substr | href
--------------------------+-----------------------------------------------------
-----
devedge.netscape.com |
http://devedge.netscape.com/viewsource/2002/bookmark
s/
texturizer.net | http://texturizer.net/firebird/extensions/
texturizer.net | http://texturizer.net/firebird/themes/
forums.mozillazine.org | http://forums.mozillazine.org/index.php?c=4
www.mozillazine.org | http://www.mozillazine.org/
devedge.netscape.com |
http://devedge.netscape.com/viewsource/2002/bookmark
s/
www.google.com | http://www.google.com/search?&q=%s
groups.google.com | http://groups.google.com/groups?scoring=d&q=%s
www.google.com |
http://www.google.com/search?q=%s&btnI=I'm+Feeling+L
ucky
dictionary.reference.com | http://dictionary.reference.com/search?q=%s
(10 rows)
--
Paul Lambert
Database Administrator
AutoLedgers
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 00:42 chester c young <chestercyoung@yahoo.com>
parent: ogjunk-pgjedan@yahoo.com
1 sibling, 1 reply; 17+ messages in thread
From: chester c young @ 2007-09-12 00:42 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; +Cc: 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/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 01:13 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: chester c young <chestercyoung@yahoo.com>
0 siblings, 3 replies; 17+ messages in thread
From: Paul Lambert @ 2007-09-12 01:13 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
chester c young wrote:
>> 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 '.*://\([^/]*)' );
>
Ok, your solution looks better than mine... but I have no idea how to
interpret that, time to consult some manuals.
--
Paul Lambert
Database Administrator
AutoLedgers
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 02:19 Andrej Ricnik-Bay <andrej.groups@gmail.com>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
2 siblings, 1 reply; 17+ messages in thread
From: Andrej Ricnik-Bay @ 2007-09-12 02:19 UTC (permalink / raw)
To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: pgsql-sql
On 9/12/07, Paul Lambert <paul.lambert@autoledgers.com.au> wrote:
> > substring( href from '.*://\([^/]*)' );
> Ok, your solution looks better than mine... but I have no idea how to
> interpret that, time to consult some manuals.
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
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 02:38 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: Andrej Ricnik-Bay <andrej.groups@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Paul Lambert @ 2007-09-12 02:38 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 03:16 ogjunk-pgjedan@yahoo.com
0 siblings, 2 replies; 17+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2007-09-12 03:16 UTC (permalink / raw)
To: pgsql-sql
Hi,
Thanks, perfect! (though I'll have to look into the regex warning):
=> select substring( href from '.*://\([^/]*)' ) as hostname from url where id<10;
WARNING: nonstandard use of escape in a string literal at character 29
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
So now I have this:
hostname
--------------------------
texturizer.net
texturizer.net
forums.mozillazine.org
www.mozillazine.org
devedge.netscape.com
www.google.com
groups.google.com
www.google.com
dictionary.reference.com
And what I'd like is something that would give me the counts for the number of occurrences of each unique hostname. Something much like `uniq -c'. Can anyone tell me how that's done or where I should look for info? (I'm not sure what to look for, that's the problem).
Thanks,
Otis
----- Original Message ----
From: chester c young <chestercyoung@yahoo.com>
To: ogjunk-pgjedan@yahoo.com
Cc: sql pgsql <pgsql-sql@postgresql.org>
Sent: Tuesday, September 11, 2007 8:42:46 PM
Subject: Re: [SQL] Extracting hostname from URI column
> 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/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 03:47 chester c young <chestercyoung@yahoo.com>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
2 siblings, 0 replies; 17+ messages in thread
From: chester c young @ 2007-09-12 03:47 UTC (permalink / raw)
To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: 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 '.*://\([^/]*)' );
> >
typo: no backslash in front of left paren
substring( href from '.*://([^/]*)' )
match up thru //
within parens, match anything except /
return match within parens
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 03:53 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: ogjunk-pgjedan@yahoo.com
1 sibling, 1 reply; 17+ messages in thread
From: Paul Lambert @ 2007-09-12 03:53 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; +Cc: pgsql-sql
ogjunk-pgjedan@yahoo.com wrote:
>
> And what I'd like is something that would give me the counts for the number of occurrences of each unique hostname. Something much like `uniq -c'. Can anyone tell me how that's done or where I should look for info? (I'm not sure what to look for, that's the problem).
>
> Thanks,
> Otis
>
Just use distinct...
test=# select distinct count(*),substring( href from '.*://([^/]*)' ) as
domain from url group by domain order by domain;
count | domain
-------+--------------------------
3 | devedge.netscape.com
1 | dictionary.reference.com
2 | forums.mozillazine.org
1 | groups.google.com
4 | texturizer.net
11 | www.google.com
2 | www.mozillazine.org
(7 rows)
--
Paul Lambert
Database Administrator
AutoLedgers
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 03:56 chester c young <chestercyoung@yahoo.com>
parent: ogjunk-pgjedan@yahoo.com
1 sibling, 0 replies; 17+ messages in thread
From: chester c young @ 2007-09-12 03:56 UTC (permalink / raw)
To: ogjunk-pgjedan@yahoo.com; +Cc: pgsql-sql
> And what I'd like is something that would give me the counts for the
> number of occurrences of each unique hostname. Something much like
> `uniq -c'. Can anyone tell me how that's done or where I should look
> for info? (I'm not sure what to look for, that's the problem).
>
select substring( ... ), count(1) from your_table group by 1;
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 03:58 ogjunk-pgjedan@yahoo.com
0 siblings, 0 replies; 17+ messages in thread
From: ogjunk-pgjedan@yahoo.com @ 2007-09-12 03:58 UTC (permalink / raw)
To: pgsql-sql
Ah, I figured out what to look for and found my uniq -c solution:
select substring( href from '.*://([^/]*)' ) as hostname, count(substring( href from '.*://([^/]*)' )) from url where id<10 group by hostname order by count desc;
hostname | count
--------------------------+-------
texturizer.net | 2
www.google.com | 2
dictionary.reference.com | 1
www.mozillazine.org | 1
devedge.netscape.com | 1
groups.google.com | 1
forums.mozillazine.org | 1
Thanks for the quick help with substring func, people!
Otis
----- Original Message ----
From: "ogjunk-pgjedan@yahoo.com" <ogjunk-pgjedan@yahoo.com>
To: pgsql-sql@postgresql.org
Sent: Tuesday, September 11, 2007 11:16:15 PM
Subject: Re: [SQL] Extracting hostname from URI column
Hi,
Thanks, perfect! (though I'll have to look into the regex warning):
=> select substring( href from '.*://\([^/]*)' ) as hostname from url where id<10;
WARNING: nonstandard use of escape in a string literal at character 29
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
So now I have this:
hostname
--------------------------
texturizer.net
texturizer.net
forums.mozillazine.org
www.mozillazine.org
devedge.netscape.com
www.google.com
groups.google.com
www.google.com
dictionary.reference.com
And what I'd like is something that would give me the counts for the number of occurrences of each unique hostname. Something much like `uniq -c'. Can anyone tell me how that's done or where I should look for info? (I'm not sure what to look for, that's the problem).
Thanks,
Otis
----- Original Message ----
From: chester c young <chestercyoung@yahoo.com>
To: ogjunk-pgjedan@yahoo.com
Cc: sql pgsql <pgsql-sql@postgresql.org>
Sent: Tuesday, September 11, 2007 8:42:46 PM
Subject: Re: [SQL] Extracting hostname from URI column
> 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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 04:03 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
0 siblings, 0 replies; 17+ messages in thread
From: Paul Lambert @ 2007-09-12 04:03 UTC (permalink / raw)
To: pgsql-sql
Paul Lambert wrote:
>
> Just use distinct...
>
> test=# select distinct count(*),substring( href from '.*://([^/]*)' ) as
> domain from url group by domain order by domain;
OK so distinct was redundant there... it gives the same results without it.
AutoDRS=# select count(*) as occurances,substring( href from
'.*://([^/]*)' ) as domain from url group by domain order by occurances
desc,domain;
occurances | domain
------------+--------------------------
11 | www.google.com
4 | dictionary.reference.com
4 | texturizer.net
3 | devedge.netscape.com
3 | groups.google.com
2 | forums.mozillazine.org
2 | www.mozillazine.org
(7 rows)
--
Paul Lambert
Database Administrator
AutoLedgers
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-12 12:52 Alvaro Herrera <alvherre@commandprompt.com>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
0 siblings, 0 replies; 17+ messages in thread
From: Alvaro Herrera @ 2007-09-12 12:52 UTC (permalink / raw)
To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: pgsql-sql
Paul Lambert wrote:
> 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.
A very good resource on regular expressions is "Mastering Regular
Expressions" by Jeffrey Friedl, now in its third edition:
http://www.oreilly.com/catalog/regex3/
I read the first ed. years ago and it was very illuminating.
--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"Acepta los honores y aplausos y perderás tu libertad"
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-16 22:54 Paul Lambert <paul.lambert@autoledgers.com.au>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
2 siblings, 2 replies; 17+ messages in thread
From: Paul Lambert @ 2007-09-16 22:54 UTC (permalink / raw)
To: pgsql-sql
Paul Lambert wrote:
> chester c young wrote:
>>> 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 '.*://\([^/]*)' );
>>
>
> Ok, your solution looks better than mine... but I have no idea how to
> interpret that, time to consult some manuals.
>
OK - following on from this, I'm doing a similar thing to the OP to
analyze my proxy's traffic (never occured to me to do it in a db until
that post)
I've done the above regex to pull out the domain part of the URL and am
left with results such as:
"acvs.mediaonenetwork.net"
"profile.ak.facebook.com"
"www.bankwest.com.au"
What I want to do next is pull out the major domain part of the URL
I.e. for the above three records I should end up with
"mediaonenetwork.net"
"facebook.com"
"bankwest.com.au"
What would be the best way to do something like that? I assume it won't
be a simple regex like the above due to the country codes on the end of
some domains. My thought is look at the last portion of the domain, if
it's 2 characters long then assume it's a country code and grab the last
three sections, if it's not three characters long then assume it's an
international domain and grab the last two... but that sounds a bit dodgy.
--
Paul Lambert
Database Administrator
AutoLedgers
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-16 23:18 Gregory Stark <stark@enterprisedb.com>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
1 sibling, 1 reply; 17+ messages in thread
From: Gregory Stark @ 2007-09-16 23:18 UTC (permalink / raw)
To: Paul Lambert <paul.lambert@autoledgers.com.au>; +Cc: pgsql-sql
"Paul Lambert" <paul.lambert@autoledgers.com.au> writes:
> What would be the best way to do something like that? I assume it won't be a
> simple regex like the above due to the country codes on the end of some
> domains. My thought is look at the last portion of the domain, if it's 2
> characters long then assume it's a country code and grab the last three
> sections, if it's not three characters long then assume it's an international
> domain and grab the last two... but that sounds a bit dodgy.
Not all countries break up their national tld space into sections like .co.uk
or .com.au. Canadian domains can be bought directly under .ca like amazon.ca.
I think you'll have to store a specific list of tlds and how deep you want to
look.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-17 14:43 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Gregory Stark <stark@enterprisedb.com>
0 siblings, 0 replies; 17+ messages in thread
From: Andrew Sullivan @ 2007-09-17 14:43 UTC (permalink / raw)
To: pgsql-sql
On Mon, Sep 17, 2007 at 12:18:56AM +0100, Gregory Stark wrote:
>
> Not all countries break up their national tld space into sections like .co.uk
> or .com.au. Canadian domains can be bought directly under .ca like amazon.ca.
>
> I think you'll have to store a specific list of tlds and how deep you want to
> look.
Another way to look at this is that any containing domain is just a
domain. So .info is a domain, example.info is a domain, and in case
of the existence of host1.some.example.info, some.example.info is a
domain. Also, co.uk is just as much a domain as yahoo.co.uk.
Some poor misguided people at Netscape badly misunderstood the DNS
many years ago, and web browser cookies have been attempting to
recover from that misunderstanding ever since (with sometimes serious
security implications). There's really no reliable way to deduce
common responsibility from the DNS labels, and it's sometimes
terrifically important not to make that mistake.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Extracting hostname from URI column
@ 2007-09-19 05:32 John Summerfield <postgres@herakles.homelinux.org>
parent: Paul Lambert <paul.lambert@autoledgers.com.au>
1 sibling, 0 replies; 17+ messages in thread
From: John Summerfield @ 2007-09-19 05:32 UTC (permalink / raw)
To: pgsql-sql
Paul Lambert wrote:
> Paul Lambert wrote:
>> chester c young wrote:
>>>> 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 '.*://\([^/]*)' );
>>>
>>
>> Ok, your solution looks better than mine... but I have no idea how to
>> interpret that, time to consult some manuals.
>>
>
> OK - following on from this, I'm doing a similar thing to the OP to
> analyze my proxy's traffic (never occured to me to do it in a db until
> that post)
>
> I've done the above regex to pull out the domain part of the URL and am
> left with results such as:
> "acvs.mediaonenetwork.net"
> "profile.ak.facebook.com"
> "www.bankwest.com.au"
>
> What I want to do next is pull out the major domain part of the URL
> I.e. for the above three records I should end up with
> "mediaonenetwork.net"
> "facebook.com"
> "bankwest.com.au"
>
> What would be the best way to do something like that? I assume it won't
> be a simple regex like the above due to the country codes on the end of
> some domains. My thought is look at the last portion of the domain, if
> it's 2 characters long then assume it's a country code and grab the last
> three sections, if it's not three characters long then assume it's an
> international domain and grab the last two... but that sounds a bit dodgy.
and csiro.au?
There may be a few others in .au too, legacies from before we went
commercial.
^ permalink raw reply [nested|flat] 17+ messages in thread
end of thread, other threads:[~2007-09-19 05:32 UTC | newest]
Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-12 00:06 Extracting hostname from URI column ogjunk-pgjedan@yahoo.com
2007-09-12 00:22 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-12 00:42 ` chester c young <chestercyoung@yahoo.com>
2007-09-12 01:13 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-12 02:19 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-09-12 02:38 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-12 12:52 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-09-12 03:47 ` chester c young <chestercyoung@yahoo.com>
2007-09-16 22:54 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-16 23:18 ` Gregory Stark <stark@enterprisedb.com>
2007-09-17 14:43 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-09-19 05:32 ` John Summerfield <postgres@herakles.homelinux.org>
2007-09-12 03:16 Re: Extracting hostname from URI column ogjunk-pgjedan@yahoo.com
2007-09-12 03:53 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-12 04:03 ` Paul Lambert <paul.lambert@autoledgers.com.au>
2007-09-12 03:56 ` chester c young <chestercyoung@yahoo.com>
2007-09-12 03:58 Re: Extracting hostname from URI column ogjunk-pgjedan@yahoo.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox