The Rule does not working.

Поиск
Список
Период
Сортировка
От King King
Тема The Rule does not working.
Дата
Msg-id afggmd$en759@imsp212.netvigator.com
обсуждение исходный текст
Список pgsql-general
Dear All,

Please help. I create below Deleted Rule in Postgres 7.1.3. But it does not
working. Please Help. That mean when I delete the record but it does not
update the table by the update command.

CREATE RULE inv_so_delete1 AS ON DELETE TO inv_detail DO UPDATE so_info SET
l_invoice = 'f'::bool WHERE ((NOT (EXISTS (SELECT inv_detail.c_sorder FROM
inv_detail WHERE (inv_detail.c_sorder = old.c_sorder)))) AND
(so_info.c_sorder = old.c_sorder));

Thanks

King King



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

Предыдущее
От: Hans-Juergen Schoenig
Дата:
Сообщение: Acessing columns of parent tables with PL/pgSQL
Следующее
От: Carl Meyer
Дата:
Сообщение: recursing down a tree