## Eric Lamer (eric.la...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
