[postgis-devel] Split By function

[Paul Ramsey]

On Jun 23, 2008, at 1:44 PM, Kevin Neufeld wrote:

> So, not only does ST_GeometryN not scale well (what is that,  
> quadratic scaling?), but it consumes all memory on my 4GB server.
>
> SELECT (ST_Dump(geom)).geom  on the other hand is linear and has no  
> problems.
>
> Unfortunately, this doesn't solve the ST_PointN equivalent problem.
>
> I suggest we add a ST_DumpPoints() method to the TODO list!

If that's the syntax you want... do you like the .path, .geom thing?  
Perhaps we should do the syntax/naming we like and document that,  
since st_dump appears to be currently unknown(ish).

P