Opened 10 years ago

Closed 9 years ago

#956 closed task (fixed)

SELECT (SRF()).* -> SELECT * FROM SRF()

Reported by: strk Owned by: strk
Priority: low Milestone: PostGIS 2.0.0
Component: topology Version: master
Keywords: Cc:

Description

I've discovered that calling:

SELECT (SRF())*;

Calls SRF() once for each column in output. As of version 8.4 this also happens if SRF() is defined as STABLE (didn't check the IMMUTABLE case).

It should be checked if ST_Dump suffers from this and carefully look for its uses (there should be a few in topology)

Change History (2)

comment:1 Changed 9 years ago by strk

Priority: mediumlow

comment:2 Changed 9 years ago by strk

Resolution: fixed
Status: newclosed

No more (SRF(..)).* as of r9165

Note: See TracTickets for help on using tickets.