Re: Typo in PL/pgSQL trigger Example 43.4? - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Typo in PL/pgSQL trigger Example 43.4?
Date
Msg-id CAKFQuwZW2qTAavt8R1c20wW_OOn9YZ9Eoz4oc8jy3+Y2en0keQ@mail.gmail.com
Whole thread Raw
In response to Typo in PL/pgSQL trigger Example 43.4?  (Kirk Parker <khp@equatoria.us>)
Responses Re: Typo in PL/pgSQL trigger Example 43.4?
List pgsql-docs
On Sat, Oct 7, 2023 at 11:11 AM Kirk Parker <khp@equatoria.us> wrote:
 
            INSERT INTO emp_audit SELECT 'D', now(), user, OLD.*; -- <= ARGUMENT IN QUESTION
 The emp_audit table has a column named 'userid', which in actual usage (next-to-last line quoted) is populated by 'user' which seems undefined in the context.  Was that intended to be 'current_user', or am I missing something?

user is a valid pseudo-function:


David J.

pgsql-docs by date:

Previous
From: Kirk Parker
Date:
Subject: Typo in PL/pgSQL trigger Example 43.4?
Next
From: Tom Lane
Date:
Subject: Re: Typo in PL/pgSQL trigger Example 43.4?