/*
CREATE OR REPLACE FUNCTION ajoute_valeurs_aleatoires(nbre integer)
RETURNS void AS $$
DECLARE
-- declarations
BEGIN
FOR i IN -179 .. 179 LOOP
FOR j IN -89 .. 89 LOOP
FOR k IN 1 .. nbre LOOP
INSERT INTO table(x,y) VALUES ( i+random() , j+random() ) ;
END LOOP ;
END LOOP ;
END LOOP ;
END;
$$ LANGUAGE plpgsql;

SELECT ajoute_valeurs_aleatoires(3) ;
*/

CREATE OR REPLACE FUNCTION mat_contig()
RETURN void AS $$
DECLARE
--
BEGIN
	SELECT cherche_voisin();
	SELECT def_poid();
	SELECT compute_poids();
END;
$$ LANGUAGE plpqsql;


CREATE OR REPLACE FUNCTION cherche_voisin(numero_de_region)
RETURN void AS $$
DECLARE
--
BEGIN


END;
$$ LANGUAGE plpqsql;

CREATE OR REPLACE FUNCTION def_poid()
RETURN void AS $$
DECLARE
--
BEGIN


END;
$$ LANGUAGE plpqsql;
CREATE OR REPLACE FUNCTION compute_poids()
RETURN void AS $$
DECLARE
--
BEGIN


END;
$$ LANGUAGE plpqsql;