Re: Summary: what to do about INET/CIDR - Mailing list pgsql-hackers

From Alex Pilosov
Subject Re: Summary: what to do about INET/CIDR
Date
Msg-id Pine.BSO.4.10.10010272319210.2291-100000@spider.pilosoft.com
Whole thread Raw
In response to Summary: what to do about INET/CIDR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
one more small request:

int8_inet(inet) and inet_int8(int8): functions to convert an inet to an
int8 and back. (not an int4, since postgres int4s are signed)

This allows me to do some additional manipulations on values. (ie. given a
host, determine its default gateway, for us, it is always first host on
that network, this could be implemented as inet_int8(int8_inet(network(x))+1), 
or splitting a cidr into two halves, 

-alex








pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Second proposal: what to do about INET/CIDR
Next
From: Alex Pilosov
Date:
Subject: Re: Re: [GENERAL] A rare error