Re: Rules versus triggers - Mailing list pgsql-general

From Justin
Subject Re: Rules versus triggers
Date
Msg-id CALL-XeORpZyTBLSjn-vw5Xhs_cKdv-P-WB420xbWiGwC57MA3A@mail.gmail.com
Whole thread Raw
In response to Rules versus triggers  (stan <stanb@panix.com>)
Responses Re: Rules versus triggers
List pgsql-general
Hi Stan

Rules actual are able to rewrite the SQL query sent to  postgresql.  Most everyone suggestion is avoid rules.

Triggers are just like every other databases Triggers firing off code for Insert/Update/Delete/Truncate event

On Sat, Mar 7, 2020 at 6:56 AM stan <stanb@panix.com> wrote:
Could someone give me a brief description of the intended functionally, and
how the 2 features work of rules, versus triggers? It appears to me that
they are simply 2 different ways to set up triggers, but I am certain that
is just because of my lack of knowledge.

Thank you.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Rules versus triggers
Next
From: Andy Colson
Date:
Subject: Re: geting results of query in plperl