> http://www.postgresql.org/docs/8.1/interactive/triggers.html > > it says something like this: > > " It is not currently possible to write a trigger function in the > plain SQL function language. "
The whole paragraph says. "It is also possible to write a trigger function in C, although most people find it easier to use one of the procedural languages. It is not currently possible to write a trigger function in the plain SQL function language." That is: you can and you should write your trigger in a procedural language. In particular - if you want to stay as closed as possible to SQL you should use procedural SQL, which in PostgreSQL is called PL/pgSQL: http://www.postgresql.org/docs/8.1/interactive/plpgsql.html Bye, Chris. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
