CREATE OR REPLACE FUNCTION membrane_paca(x1 character(2))
RETURNS void AS $$
DECLARE
--
BEGIN
	  
	-- création des vues des department contigu
	CREATE TABLE reg_1 AS
	(SELECT * FROM departement WHERE departement.code_reg LIKE 'x1');

	
END;
$$ LANGUAGE plpgsql;

SELECT membrane_paca('93');