Re: Calling a function from a rule?

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Calling a function from a rule?
Дата
Msg-id 0a22aafe-9a3a-78b5-84e3-88c98512cba9@postgresfriends.org
обсуждение исходный текст
Ответ на Calling a function from a rule?  (stan <stanb@panix.com>)
Ответы Re: Calling a function from a rule?
Список pgsql-general
On 04/03/2020 14:05, stan wrote:
> I am missing something about how to properly create a rule.

What you are missing is that you should not ever use RULEs.

> Thanks to the helpful folks on this list, I am looking a creating some
> update able views. So, looks like I need to create a rule and a function
> for this.

Use an INSTEAD OF trigger on the view unless it's a simple view in which
case it "just works".
-- 
Vik Fearing



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

Предыдущее
От: Hernan Jesus Gonzalez Carmona
Дата:
Сообщение: Re: Exportacion por lotes
Следующее
От: stan
Дата:
Сообщение: Re: Calling a function from a rule?