Skip site navigation (1) Skip section navigation (2)

Re: Incrementing INET fields

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Peter Nixonn <listuser(at)peternixon(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incrementing INET fields
Date: 2006-11-28 14:10:00
Message-ID: 20061128141000.GB29938@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Nov 28, 2006 at 12:17:20AM +0200, Peter Nixonn wrote:
> On a related note we also wrote an ippool module for radius which needs to
> have a prepopulated sqltable of ip addresses which it then hands out. Being
> able to prepopulate the table with a 10.0.0.0/8 or 192.168.0.0/24 range
> with a simple loop would be very usefull.

Seems to me you could do this with generate_series() and an int4 ->
inet conversion function.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-11-28 14:53:12
Subject: Re: Potential to_char localization bug
Previous:From: Markus SchiltknechtDate: 2006-11-28 13:19:51
Subject: Re: Integrating Replication into Core

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group