vac=> create table t (x int);CREATEvac=> insert into t values (1);INSERT 18579 1vac=> insert into t values (1);INSERT 18580 1vac=> insert into t values (2);INSERT 18581 1vac=> select x from t group by x having count(*) > 1;x-1(1 row)
Vadim