> 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;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
