Re: point types in "DISTINCT" queries - Mailing list pgsql-general

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
mightwork: 
>
>     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