Re: Calling a function from a rule?

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Calling a function from a rule?
Date: 2020-03-04 14:04:34
Message-ID: 0a22aafe-9a3a-78b5-84e3-88c98512cba9@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2020-03-04 14:19:24 Re: Calling a function from a rule?
Previous Message Hernan Jesus Gonzalez Carmona 2020-03-04 13:58:14 Re: Exportacion por lotes