Re: SQL question.... - Mailing list pgsql-sql

.... assuming the following schema:

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.

I've not figured out how to do this; I can get a list of all IPs and names ordered by IP, which I could then parse with a different program (e.g. "Select name, address from access order by address"), but the idea of course is to do it with one SELECT statement and return only rows that have multiple names listed for a given IP.