horizontalno particionisanje

CREATE TABLE "vip_extra_service" (
  CHECK ("extra_service_type_id" >= 5)
) INHERITS ("extra_service");

CREATE TABLE "regular_extra_service" (
  CHECK ("extra_service_type_id" < 5)
) INHERITS ("extra_service");

CREATE OR REPLACE FUNCTION extra_service_insert_trigger()
RETURNS TRIGGER AS $$

BEGIN

  IF (NEW.extra_service_type_id >= 5) THEN
    INSERT INTO vip_extra_service VALUES (NEW.*);
  ELSIF (NEW.extra_service_type_id < 5) THEN
    INSERT INTO regular_extra_service VALUES (NEW.*);
  ELSE
    RAISE EXCEPTION 'Date out of range. Please fix the extra_service_insert_trigger() function.';
  END IF;

  RETURN NULL;
END;

$$ LANGUAGE plpgsql;

CREATE TRIGGER extra_service_insert_trigger
BEFORE INSERT ON extra_service
FOR EACH ROW EXECUTE PROCEDURE extra_service_insert_trigger();