Trigger function language

Started by Vincenzo Romanoover 16 years ago2 messagesgeneral
Jump to latest
#1Vincenzo Romano
vincenzo.romano@notorand.it

Hi all.
Is there any performance difference in writing trigger function in SQL
rather than PL/PgSQL?
In my case the body would actually be 1 line.

--
Vincenzo Romano
NON QVIETIS MARIBVS NAVTA PERITVS

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Vincenzo Romano (#1)
Re: Trigger function language

Vincenzo Romano <vincenzo.romano@notorand.it> writes:

Is there any performance difference in writing trigger function in SQL
rather than PL/PgSQL?

SQL functions don't support being called as triggers, so performance
questions are a bit beside the point ...

regards, tom lane