readthefuckingmanual.net

[SOLVED] ERROR: SQL functions cannot return type "trigger"

Error added: 2005-12-01T18:32:58Z

0 people waiting for the answer...

1 answers found.

You can\'t write triggers in SQL, only in PL/pgSQL. Make sure you say \"CREATE FUNCTION function_name() RETURNS TRIGGER AS \'...\' LANGUAGE plpgsql\".

Check http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html for more info.

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: