[postgis-users] Chained Intersections?

[Mark Cave-Ayland]

On Tue, 2006-10-10 at 06:22 -0700, Curtis W. Ruck wrote:

(cut)

> DECLARE
>     total_count int := 0;
>     current_level_count int := 0;
>     first_id_of_previous_level int := 0;
>     last_id_of_previous_level int:= 0;
>     num_intersections int ARRAY[0];
>     geometries geometry ARRAY[0];


Hi Curtis,

The declarations for num_intersections and geometries look strange - I'm
not sure the PostgreSQL parser can correctly determine they are arrays
from your definitions. Can you try something like this:

	num_intersections int[];
	geometries geometry[];


Kind regards,

Mark.