Thread: Trigger function language

Trigger function language

From
Vincenzo Romano
Date:
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

Re: Trigger function language

From
Tom Lane
Date:
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