plpgsql - simulating materialized view

Hi,

I have a db with +100.000 records. two fields (type and lang) are indexed and content only a set of value (type: from 1 to 3, lang: FR, EN or ES)

I want to know how much records have type=1, type=2, type=3, lang=FR, lang=EN, lang=ES

I create two views:

Code:

---

SELECT type, COUNT(*) FROM obj GROUP BY type;
SELECT lang, COUNT(*) FROM obj GROUP BY lang;

 **view1**    **view2**
 type  cpt      lang  cpt
 1      10000    FR    20000
 2      60000    EN    30000
 3      30000    ES    50000

---

Then I create a table "matview" with 3 fields (type, value, cpt). And I'dlike to fill the values like this

Code:

---

**matview**
type  value cpt
TYPE  1    10000
TYPE  2    60000
TYPE  3    30000
LANG  FR    20000
LANG  EN    30000
LANG  ES    50000

---

I want to create a function pl/pgsql that refresh the "matview" table with the values of my two views. I don't know enough pl/pgsql to do it. My function have an error and I'm stuck!

Here's the code of my function :

Code:

---

CREATE FUNCTION refresh_mview() RETURNS integer AS '
DECLARE
    rec  RECORD;
BEGIN
    DELETE FROM matview;
    FOR rec IN SELECT * FROM view1 LOOP
        INSERT INTO matview VALUES(''TYPE'','' || rec2.type || '','' || rec2.cpt || '')'';
    END LOOP;
    FOR rec IN SELECT * FROM view2 LOOP
        INSERT INTO matview VALUES(''LANG'','' || rec2.lang || '','' || rec2.cpt || '')'';
    END LOOP;
    RETURN 1;
END;
' LANGUAGE plpgsql;

---

Can anybody help me, please ? Do you think there's a better solution (for the speed) ? Thanks for the help.