[postgis-devel] Split By function

Martin Davis mbdavis at refractions.net
Mon Jun 23 14:18:42 PDT 2008


This is one function which really needs a code example to show how to 
use it.  The description is very confusing to people (like me) who are 
unfamiliar with SRF's and UDT's (or whatever the set contains - 
presumably some kind of object?)

But clearly a very useful function.

Paul Ramsey wrote:
>
> 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
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022




More information about the postgis-devel mailing list