On 7/3/20 5:01 μ.μ., Justin wrote:
Yes a rule can rewrite query or replace the query
Read through Depesz post about rules and the weird side affects that can occurr
https://www.depesz.com/2010/06/15/to-rule-or-not-to-rule-that-is-the-question/
IMHO Rules are cool. It allows for more elegant
Yes a rule can rewrite query or replace the query
Read through Depesz post about rules and the weird side affects that can
occurr
https://www.depesz.com/2010/06/15/to-rule-or-not-to-rule-that-is-the-question/
On Sat, Mar 7, 2020 at 9:57 AM stan wrote:
> On Sat, Mar 07, 2020 at 09:47:39AM
On Sat, Mar 07, 2020 at 09:47:39AM -0500, Justin wrote:
> 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
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
https://www.postgresql.org/docs/current/sql-createtrigger.html
On
On 07/03/2020 11:56, stan 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