Re: [GENERAL] CIDR data type query help

2010-05-20 Thread Scot Kreienkamp
m -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins Sent: Wednesday, May 19, 2010 2:18 PM To: pgsql-general General Subject: Re: [GENERAL] CIDR data type query help On May 19, 2010, at 10:32 AM, Scot Kreienkamp wrot

Re: [GENERAL] CIDR data type query help

2010-05-19 Thread Steve Atkins
On May 19, 2010, at 10:32 AM, Scot Kreienkamp wrote: > Hi everyone, > > I have a column of type CIDR in a table that I am querying that contains > the values of 10/8, 10.1/16,10.1.28/24, and 10.1.28.95. I am trying to > return only the one record that's most specific compared to the IP > addres