Re: Need help with Inet type

## Eric Lamer (eric.lamer@intact.net):

>   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.

How about:
   SELECT DISTINCT logs.* FROM logs
     JOIN ip_table ON logs.srcip << ip_table.ip
     WHERE zone = 'ZONE_a';

Regards,
Christoph

--
Spare Space