I have an employees table and one column in the employees table is "supervisor_id" which is an FK to the id column.
I have employees from numerous companies all in the same table. I have a column called company_id that indicates the company. I want to make sure that an employee chooses a supervisor from the same company. I have a column called company_ID. How do I make sure that the employee company ID matches the supervisor's company ID? Do I need to use a trigger or is there a way I can do this with foreign keys? TIA Matt -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
