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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
