searching cidr/inet arrays - Mailing list pgsql-sql

From Rob Casson
Subject searching cidr/inet arrays
Date
Msg-id fddc0c5705042511464f94be68@mail.gmail.com
Whole thread Raw
Responses Re: searching cidr/inet arrays  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
i'm having trouble figuring out how to search in inet arrays....its
been a long time since i used postgres array support, so i may just be
bone-headed......

how can i determine if a given ip address is contained in the subnet
declaration inside an array?
   {134.53.25.0/24,134.53.0.0/16}   {134.53.24.0/24}

i'd like to see which rows match an ip of, say, 134.53.24.2.....

thanks in advance, and sorry if this is a faq....i've googled
site:archives.postgresql.org, but haven't found my solution.....


pgsql-sql by date:

Previous
From: Theodore Petrosky
Date:
Subject: Re: to_char(interval) ?
Next
From: Michael Fuhr
Date:
Subject: Re: searching cidr/inet arrays