On Tue, 25 Nov 2014 21:41:12 +0100 Alban Hertroys <haram...@gmail.com> wrote:
> Hi all, > > In the past, when writing trigger functions, I?ve always used pl/pgsql > without giving it a second thought. Today I was modifying a database creation > script that was originally intended for Firebird to work with Postgres and > the example trigger procedures in there were very close to pure SQL. > > Hence, I started rewriting them as SQL functions, but is that really > possible? The return-type for trigger functions is usually ?returns trigger?, > which I don?t know how to translate to SQL. Next to that, what should the SQL > statement inside the function be returning? Last I checked, triggers had to be written in a language that could "return trigger". A look at the 9.4 documentation seems to suggest that this is still a requirement, although I didn't find a definitive statement to that effect. Since stored procedures written in SQL are unable to return the trigger type, it's not currently possible to write triggers in SQL. -- Bill Moran I need your help to succeed: http://gamesbybill.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
