Alban Hertroys <haramrae@gmail.com> writes:
> In the past, when writing trigger functions, I’ve always used pl/pgsql without giving it a second thought. Today I
wasmodifying a database creation script that was originally intended for Firebird to work with Postgres and the example
triggerprocedures in there were very close to pure SQL.
> Hence, I started rewriting them as SQL functions, but is that really
> possible?
No, nobody's ever tried to make that work. It could probably be done
with sufficiently many round tuits, but it's not clear that there's
any benefit that would justify the work. Surely dropping some SQL
commands into plpgsql isn't very hard ...
regards, tom lane