Re-write rules on views

Поиск
Список
Период
Сортировка
От Rip
Тема Re-write rules on views
Дата
Msg-id 5.1.0.14.2.20020226192846.009ed850@mail.onlineinfo.net
обсуждение исходный текст
Ответы Re: Re-write rules on views
Список pgsql-general
Hi all,
    The docs seem slim in this department.. what is the proper syntax for an
update to a view with multiple tables?

Here's a view I'd like to update:

  CREATE VIEW "users_perms_view" AS
      SELECT
           users.user_id,
         users.username,
         users.name_first,
         users.name_last,
         permissions.permission_name,
         permissions.permission_description
      FROM
           users,
         users_permissions,
         permissions
      WHERE
           ((users_permissions.user_id = users.user_id) AND
         (users_permissions.permission_id = permissions.permission_id));

This rule works fine as far as it goes:

CREATE RULE "update_users_perms_view" AS
    ON UPDATE TO users_perms_view DO INSTEAD
    UPDATE
        users SET
          username = NEW.username,
        password = NEW.password,
        name_first = NEW.name_first,
        name_last = NEW.name_last,
        active = NEW.active,
    WHERE
        user_id = OLD.user_id;

How do I update the  users_permissions and  permissions table?

Thanx,


В списке pgsql-general по дате отправления:

Предыдущее
От: cbbrowne@acm.org
Дата:
Сообщение: Re: [ANNOUNCE] [pgsql-advocacy] eWeek Poll: Which database is most critical to your organization?
Следующее
От: Zak Greant
Дата:
Сообщение: Re: eWeek Poll: Which database is most critical to your