Opened 11 years ago

Closed 9 years ago

#2285 closed defect (fixed)

standardize_address should no longer be marked as SETOF

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.2.0
Component: pagc_address_parser Version: master
Keywords: Cc:

Description

Steve,

I assume now with your changes that standardize_address is guaranteed to return just one answer, but its still marked as SETOF which could have some consequences as to how people can call it and how PostgreSQL will optimize it.

Change History (3)

comment:1 by robe, 11 years ago

While you are at it you should put a cost on these functions otherwise they default to 1 for C functions which isn't good as they would be more likely to be recomputed in cases where the planner has a choice.

I would say a cost of 100 or 200 would be good to start.

comment:2 by robe, 11 years ago

Milestone: PostGIS 2.1.0PostGIS 2.2.0

comment:3 by robe, 9 years ago

Resolution: fixed
Status: newclosed

fixed at r13849

Note: See TracTickets for help on using tickets.