Re: triggers and functions in pgsql 7.0.2

Marc Britten wrote:
>
> I'm going through your docs trying to create a function and a trigger that
> calls said function, what I've gotten so far is
>
> CREATE FUNCTION create_count_cache()
> RETURNS opaque AS
> '
> BEGIN;
> DELETE FROM SnipCount;
> INSERT INTO SnipCount SELECT LangID, COUNT(LangID) AS CNT FROM
> snippet GROUP BY LangID;
> COMMIT;
> '
> LANGUAGE 'sql';
>
> CREATE TRIGGER count_change
> AFTER DELETE OR INSERT ON snippet FOR EACH ROW
> EXECUTE PROCEDURE create_count_cache();
>
> however LANGUAGE sql cannot return opaque and plpgsql is not a known lang
> type.
>
> it seems that all your docs are a bit out of date, can you give me some help
> please?
>
> marc britten

The link below might help:

http://www.postgresql.org/docs/programmer/xplang.htm#XPLANG-TITLE

Hope that helps,

Mike Mascari