> create table access (name text, address ip)
>
> I want to construct a SELECT statement which will return ONLY tuples
> containing IP and name pairs IF there is an IP that has two or more
> NAMEs associated with it.
>
>
many ways:
select a1.* from access a1 where exists( select 1 from access a2 where a2.name=a2.name and a1.ip!=a2.ip );
select a1.*
from access a1
join access a2 using( name )
where a1.ip != a2.ip;