From: | "Simon (dot)(dot)(dot)" <wedgetail_e(at)hotmail(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Testing if a Column Exists in a NEW record of a Trigger Function |
Date: | 2014-01-07 04:15:52 |
Message-ID: | SNT149-W446BFBDC8079E84B9D632D91B60@phx.gbl |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear List,
As part of the Audit process in my psql database, I have a standard set of columns "InsertBy", "InsertTime", "LastUpdateBy" & "LastUpdateTme". I use a standard Trigger function [listed below] to ensure the correct details are added to each record.
However, on some data tables where data is only imported and not updated, the "Update" columns are not required.
As such, is there a way to test the NEW record variable to see if the column "LastUpdateBy" exists? I could not find any information in the manual to describe how this might be done.
Thanks
Simon
CREATE OR REPLACE FUNCTION "Security"."InsertStamp"() RETURNS trigger as $InsertStamp$
DECLARE
UserID integer;
BEGIN
SELECT "IDUser" INTO UserID FROM "Security"."User" WHERE "Username" = current_user;
NEW."InsertBy" := UserID;
NEW."InsertTime" := current_timestamp;
NEW."LastUpdateBy" := UserID;
NEW."LastUpdateTime" := current_timestamp;
RETURN NEW;
END;
$InsertStamp$ LANGUAGE plpgsql STABLE SECURITY DEFINER;
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Kumar | 2014-01-07 08:39:32 | Re: Testing if a Column Exists in a NEW record of a Trigger Function |
Previous Message | Pagett, Lacey | 2014-01-06 23:48:44 | Re: 0FATAL: too many connections for database |