I have point geometries in a PostGIS table. I want to select only the distinct geometries from this table. If a geometrie is duplicated, it should select the first appearance in the table.
I tried to following query:
SELECT DISTINCT ON(wkb_geometry), ogc_fid from points;
But I get the error:
ERROR: syntax error at or near ","
What is wrong with the query?