Opened 10 years ago

Closed 10 years ago

#2609 closed enhancement (fixed)

topogeo_AddPolygon get rid of DISTINCT

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS 2.1.2
Component: topology Version: 2.1.x
Keywords: Cc:


I noticed that topogeo_AddPolygon has a DISTINCT

'SELECT DISTINCT f.face_id FROM ' || quote_ident(atopology)
    || '.face f WHERE f.mbr && '
    || quote_literal(apoly::text)
    || '::geometry';

Which seems totally pointless given that face_id is the primary key of face. I'm sure PostgreSQL is probably smart enough to figure it doesn't need to but it shouldn't be bothered.

Am I missing something?

Change History (1)

comment:1 by robe, 10 years ago

Resolution: fixed
Status: newclosed

fixed for 2.1.2 at r12317 and trunk 2.2.0 (at r12316 )

Note: See TracTickets for help on using tickets.