![]() ![]() This can be a simple statement such as SELECT or INSERT, or it can be a compound statement written using BEGIN and END. Click -> Trigger Function to open an object list for Trigger Function.ĭefinition consists of a valid SQL procedure statement. A trigger is defined with the SQL CREATE TRIGGER command, whereas trigger functions are defined using the SQL CREATE FUNCTION command. The definition of a trigger and the definition of its associated trigger function are two different things. ![]() A PL/pgSQL trigger function can be referenced by a trigger as the operation to be performed when the trigger's event occurs. Triggers define operations that are performed when a specific event occurs within the database. The term "trigger function" is a simply a way of referring to a function that is intended to be invoked by a trigger. Trigger Function can be created with PL/pgSQL and referenced within a PostgreSQL trigger definition.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |