appropriate column for storing ipv4 address

[jonathan vanasco <postgres@xxxxxxxx>]

I have to store/search some IP data in Postgres 9.6 and am second-guessing my storage options.  

Would anyone mind giving this a quick look for me?

Right now I have two tables, and am just using cidr for both:

	create table tracked_ip_address (
		id SERIAL primary key,
		ip_address CIDR not null
	);

	create table tracked_ip_block (
		id SERIAL primary key,
		block_cidr CIDR not null,
		ownserhip_data TEXT
	);

The types of searching I'm doing:
	
	1. on tracked_ip_address, I'll search for neighboring ips.  
		e.g.
 		select * from tracked_ip_address where ip_address << '192.168'::CIDR;
 		select * from tracked_ip_address where ip_address << '192.168.1'::CIDR;

	2. on tracked_ip_block, i search/join against the tracked_ip_address to show known ips in a block, or a known block for an ip.

i used cidr instead of inet for the ip_address because it saved me a cast on joins and appears to work the same.  was that the right move?  is there a better option?

thanks in advance.

/ jonathan

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general