[SOLVED] Re: A question about trigger fucntion syntax

2019-08-11 Thread stan
On Sun, Aug 11, 2019 at 05:31:13PM -0400, stan wrote: > I trimmed this thread quite a bit. > > Thanks to the help I have received, I am making progress. I have looked a the > recommended documentation, and I believe I am close. I have utilized the > "debugging printf" capability here. Here is wher

Re: A question about trigger fucntion syntax

2019-08-11 Thread stan
I trimmed this thread quite a bit. Thanks to the help I have received, I am making progress. I have looked a the recommended documentation, and I believe I am close. I have utilized the "debugging printf" capability here. Here is where I am. I have the following function create. DROP TRIGGER val

Re: A question about trigger fucntion syntax

2019-08-11 Thread Pavel Stehule
Hi > BTW, here is what I Ave tried. > > CREATE OR REPLACE FUNCTION check_permission() > RETURNS trigger AS > $BODY$ > BEGIN > SELECT > permit > FROM > permitted_work > WHERE > NEW.employee_key = OLD.employee_key > A

Re: A question about trigger fucntion syntax

2019-08-11 Thread stan
On Sun, Aug 11, 2019 at 08:56:13AM -0400, stan wrote: > Good morning (at least is is morning East Coast USA time). > > I am trying to create a function to validate an attempted record > insert, and I am having a hard time coming up with syntax that > is acceptable. > > Here is the scenario I hav