[postgis-devel] polygonize

[strk at refractions.net]

On Mon, Dec 20, 2004 at 09:48:38AM -0500, Carl Anderson wrote:
> strk at refractions.net wrote:
> 
> >On Sun, Dec 19, 2004 at 02:09:56PM -0500, Carl Anderson wrote:
> > 
> >
> >>strk at refractions.net wrote:
> >>
> >>   
> >>
> >>>On Sun, Dec 19, 2004 at 11:22:09AM -0500, Carl Anderson wrote:
> >>>
> >>>
> >>>     
> >>>
> >>>>btw
> >>>>
> >>>>select polygonize_garray(array_append('{}',the_geom) from shapes;
> >>>>Causes a backend ABEND;
> >>>> 
> >>>>
> >>>>       
> >>>>
> >>>Does collect_garray(array_append('{}',the_geom) from shapes work ?
> >>>
> >>>--strk;
> >>>
> >>>
> >>>     
> >>>
> >>That also ABENDs the backend;
> >>
> >>C.
> >>   
> >>
> >
> >This is an old problem. The problem is that collect_garray expects
> >an array of PG_LWGEOM *pointers*, while array_append builds an array
> >of PG_LWGEOM *toasts*.
> >
> >Those queries should work if written as:
> >
> >select polygonize_garray(geom_accum('{}',the_geom) from shapes;
> >select collect_garray(geom_accum('{}',the_geom) from shapes;
> >
> >--strk;
> >
> > 
> >
> 
> (rhetorical questions follow)
> But
> polygonize_garray is declared to accept  geometry[].
>    is the data type geometry[] intended to be polymorphic?  (pointers 
> or TOAST)
> or do
>       geom_accum, collect_garray and polygonize_garray
>       all agree to support something else when passed the geometry[] 
> datatype?
> 
> select  array_append('{}',the_geom) from shapes limit 2;
>                      array_append
> ---------------------------------------------------------------------
> {SRID=2240;01060000000010000....}
> {SRID=2240;01060000000010000...}
> {SRID=2240;01060000000010000...}
> 
> select geom_accum('[]',the_geom) from shapes limit 2;
>                    geom_accum
> ---------------------------------------------------------------------
> [808333614:808333614] = {0100000000}
> [32:32] = {0100000000}
> [32:32] = {0100000000}

Ok, we are cheating.
I'll make some research on supporting real arrays.
--strk;

> 
> 
> C.
> 
> -- 
> Carl Anderson
> GIS Manager Fulton County, Georgia
> carl.anderson at co.fulton.ga.us
> 404.730.8026
> 
> 
> -----------------------------------------------------
> This message has been scanned for viruses and
> dangerous content for Fulton County by DefendMail, and is
> believed to be clean.
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel