IP addresses

From: "Tom Allison" <tom(at)tacocat(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: IP addresses
Date: 2007-11-19 13:26:20
Message-ID: aa6023de0711190526o40c7c32cs58279b196d4577ef@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am planning on doing a LOT of work with ip addresses and thought that the
inet data type would be a great place to start.

But I'm not sure how this works in with accessing the addresses. In perl or
ruby how is the value returned?
Or should I stricly use host() and other functions to be explicit about what
I'm doing.

Another question.
Given a subnet (eg: 192.168.1.0/24) is there some way to pull all the
addresses therein?
I can do this in code - but I was curious if there was a postgres way of
doing it (didn't see any, but..)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2007-11-19 13:44:41 Re: tsearch2 best practices
Previous Message Bill Moran 2007-11-19 13:24:08 Re: Calculation for Max_FSM_pages : Any rules of thumb?