Обсуждение: Agregation Function

Hi, i have to create an agregation function.. what is the syntax.

The function to be agregation is :

DROP FUNCTION "polygon_agregation"(polygon);
CREATE FUNCTION "polygon_agregation"(polygon) RETURNS box AS 'DECLARE
polygons_to_agregate ALIAS FOR $1
BEGIN
agregated_polygons = NULL;

FOR poly IN polygons_to_agregate LOOP
IF agregated_polygons = NULL THEN agregated_polygons = box(poly);
agregated_polygons = box(agregated_polygons, box(poly));
END LOOP;

RETURN agregated_polygons,
END' LANGUAGE 'plpgsql'

Thanx

Pierre-Yves Landuré