pew

CREATE TABLE Workers
(
  worker_id integer NOT NULL,
  department_id integer NOT NULL,
  first_name text NOT NULL,
  second_name text NOT NULL,
  phone_number text NOT NULL,
 CONSTRAINT workers_pkey PRIMARY KEY (worker_id)
);

CREATE TABLE Workers_1
(
  worker_id integer NOT NULL,
  CHECK ( department_id==1 ),
  CONSTRAINT workers_pkey PRIMARY KEY (worker_id)
) INHERITS (analytics.events);




CREATE OR REPLACE FUNCTION workers_insert_trigger()
RETURNS TRIGGER AS $$
BEGIN
  IF (NEW.departament_id = 1) THEN
    INSERT INTO Workers_1 VALUES (NEW.*);
  ELSE
    INSERT INTO Workers VALUES (NEW.*);;
  END IF;
  RETURN NULL;
END;
$$
LANGUAGE plpgsql;

INSERT INTO Workers ( worker_id, department_id , first_name,second_name,phone_number) VALUES
('1', '1', 'Ivan','Ivanov','88005553535');
INSERT INTO Workers ( worker_id, department_id , first_name,second_name,phone_number) VALUES
('2', '2', 'Petr','Petrov','88005553536');

CREATE TRIGGER events_before_insert
  BEFORE INSERT ON Workers
  FOR EACH ROW EXECUTE PROCEDURE wokers_insert_trigger();