searching cidr/inet arrays

From: Rob Casson <rob(dot)casson(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: searching cidr/inet arrays
Date: 2005-04-25 18:46:37
Message-ID: fddc0c5705042511464f94be68@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.....

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-04-25 20:24:06 Re: searching cidr/inet arrays
Previous Message Tony Wasson 2005-04-25 15:51:40 Re: Looking for a way to sum integer arrays....