[Solved] Which of the following is the correct way to start a trigger function in PostgreSQL? — Ans: CREATE FUNCTION my_trigger() RETURNS trigger AS $ BEGIN RETURN NEW; END; $... | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

Which of the following is the correct way to start a trigger function in PostgreSQL?

ACREATE FUNCTION my_trigger() RETURNS trigger AS $$ BEGIN RETURN NEW; END; $$ LANGUAGE plpgsql;

BCREATE FUNCTION my_trigger() RETURNS boolean AS $$ BEGIN RETURN TRUE; END; $$ LANGUAGE plpgsql;

CCREATE TRIGGER my_trigger() RETURNS trigger AS $$ BEGIN RETURN OLD; END; $$ LANGUAGE plpgsql;

DCREATE FUNCTION my_trigger() RETURNS void AS $$ BEGIN END; $$ LANGUAGE plpgsql;

Step-by-Step Solution

Solution:

Step 1: Check syntax for trigger function creation
Trigger functions must be created with CREATE FUNCTION, return type trigger, and use plpgsql language.
Step 2: Identify correct function body and return statement
Trigger functions must return NEW or OLD row, so RETURN NEW; is correct here.
Final Answer:
CREATE FUNCTION my_trigger() RETURNS trigger AS $$ BEGIN RETURN NEW; END; $$ LANGUAGE plpgsql; -> Option A
Quick Check:
Trigger function syntax = CREATE FUNCTION my_trigger() RETURNS trigger AS $$ BEGIN RETURN NEW; END; $$ LANGUAGE plpgsql; [OK]

Quick Trick: Trigger functions use RETURNS trigger and RETURN NEW or OLD [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct way to start a trigger function in PostgreSQL?