[postgis-users] Chained Intersections?

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Wed Oct 11 03:48:23 PDT 2006


On Tue, 2006-10-10 at 15:31 -0700, Curtis W. Ruck wrote:
> Negative, i tried that with the below as the function declaration to
> no avail.  The handle all higher levels section isn't finding anything
> in the arrays.  Anyone else have a suggestion on how to store data
> within a function without creating a temporary table?
> 
> Curtis


Hi Curtis,

Looking at the code you just posted, you have this line here:

	geometries := array_append(geometries, temp_geom);

but I can't see where temp_geom is being set within your PLPGSQL
function? Should it be the_geom? Another trick would be to add something
like:

	RAISE NOTICE 'geometries count: %', array_upper(geometries, 1);

which should show the size of your arrays increasing as the function
runs.


HTH,

Mark.





More information about the postgis-users mailing list