[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