On Wed, 2011-06-29 at 11:37 -0400, Jonathan S. Katz wrote: > Which means it *should* work, but first I would need to clean up the data and find the duplicates. I was hoping this might work: > > SELECT geocode, count(*) > FROM a > GROUP BY a.geocode > HAVING count(*) > 1; Maybe you could use a self-join as a workaround for now, just to clean up the data? SELECT geocode, other_columns from a a1, a a2 where a1.other_columns <> a2.other_columns and a1.geocode ~= a2.geocode; Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
