On 8/7/19 11:07 AM, stan wrote:
> Have table that contains employee keys, paired up with work type keys
> (both foreign keys) and a 3rd column that you enter a billing rate in.
> Then I have a table where employees enter their work. I need to validate
> that the employee, work type pair exists, before allowing the new record
> to be inserted.
>
> Any thoughts as to good way to do this?
INSERT UPDATE trigger:
https://www.postgresql.org/docs/11/sql-createtrigger.htmlhttps://www.postgresql.org/docs/11/plpgsql-trigger.html
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com