"Razvan Costea-Barlutiu" <cbrazvan@xxxxxxxxxx> writes: > Hello. > > Facts: > 1. System: Win2003 > 2. Postgres 8.2 Is that just 8.2 or 8.2.x? Which x? > This has way too many ramifications for me to follow so I do appreciate some > guidance. What do the outputs of these queries say? select count(*),count(distinct suid) from mt; select suid,count(*) from mt group by suid having count(*) > 1; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend