CREATE TABLE rights (
    id SERIAL,
    name varchar( 50 ) NOT NULL,
    title varchar( 255 ),
    CONSTRAINT uniq_right_name UNIQUE( name )
);

CREATE TABLE rights_order (
) INHERITS ( rights );
INSERT INTO rights_order ( name, title ) VALUES ( 'orderAccess', 'Доступ к заявкам' );
INSERT INTO rights_order ( name, title ) VALUES ( 'orderAdd', 'Добавление заявки' );
INSERT INTO rights_order ( name, title ) VALUES ( 'orderEdit', 'Редактирование заявки' );
INSERT INTO rights_order ( name, title ) VALUES ( 'orderDel', 'Удаление заявки' );

CREATE TABLE rights_outerChat (
) INHERITS ( rights );
INSERT INTO rights_outerChat ( name, title ) VALUES ( 'outerChatAccess', 'Доступ к внешнему чату' );

CREATE TABLE groups (
    id SERIAL,
    title varchar( 255 ) NOT NULL,
    rights integer[]
);

INSERT INTO groups ( title, rights ) VALUES ( 'Операторы', '{1,5}' );

SELECT array( SELECT id FROM rights_order );

SELECT rights FROM groups WHERE id = 1;

SELECT ( SELECT array( SELECT id FROM rights_order ) ) && ( SELECT rights FROM groups WHERE id = 1 );