Hi,
I would like to know if
there is a way to do what I need with Postgress.
I have a table with logs
and a table with a list of subnets.
Right now I do the following
query in my table:
Select * From logs Where
src_ip << '10.0.0.0/24' OR src_ip << '10.1.0.0/24' OR src_ip
<< '172.168.1.0/28';
I would like to simplify
that query and use a table instead as the source of the subnet I want to
check.
I have a table that contain
a list of subnet and zone name:
ZONE_a 10.0.0.0/24
ZONE_a 10.1.0.0/24
ZONE_a 172.16.1.0/28
ZONE_b 10.2.0.0/24
ZONE_b 10.3.0.0/24
I can do something like:
Select * From logs Where
src_ip IN (Select ip from ip_table where zone = 'ZONE_a');
Of course that does not
work since it does not work with Inet type and I cannot use << because
I have more than 1 row return from the second select.
Is there a way to achive
that?
Thanks.
_______________________
Eric Lamer
IT Security Specialist
INTACT Financial Corporation
(450) 778-9580 ext. 3744
