Writing my first trigger
От | Chris Tsongas |
---|---|
Тема | Writing my first trigger |
Дата | |
Msg-id | CAPhBOiiW8jk_2wcKvCik1eXNejS10qwfGuuovPk0Q=5kvHNxNw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Writing my first trigger
Re: Writing my first trigger Re: Writing my first trigger |
Список | pgsql-novice |
Working on my first trigger to create a fullName value from firstName, optional preferredFirstName, and lastName fields, where the full name uses the optional preferred first name if it exists, otherwise it uses the first name and of course the required last name. Would be great to get feedback on the following code before I try running it (note I already have an employee table, just including the CREATE TABLE statement for clarity): CREATE TABLE employee ( firstName text NOT NULL, preferredFirstName text, lastName text NOT NULL, fullName text, ); CREATE OR REPLACE FUNCTION update_employee() RETURNS TRIGGER AS $$ BEGIN IF (OLD."preferredFirstName" IS NOT NULL) THEN NEW."fullName" = OLD."preferredFirstName" || ' ' || OLD."lastName"; ELSE NEW."fullName" = OLD."firstName" || ' ' || OLD."lastName"; END IF; NEW."updatedAt" = now(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER fullName INSTEAD OF INSERT OR UPDATE ON employee FOR EACH ROW EXECUTE FUNCTION update_employee();
В списке pgsql-novice по дате отправления: