Re: Calling a function from a rule? - Mailing list pgsql-general

From Vik Fearing
Subject Re: Calling a function from a rule?
Date
Msg-id 0a22aafe-9a3a-78b5-84e3-88c98512cba9@postgresfriends.org
Whole thread Raw
In response to Calling a function from a rule?  (stan <stanb@panix.com>)
Responses Re: Calling a function from a rule?  (stan <stanb@panix.com>)
List 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 by date:

Previous
From: Hernan Jesus Gonzalez Carmona
Date:
Subject: Re: Exportacion por lotes
Next
From: stan
Date:
Subject: Re: Calling a function from a rule?