Re: Rules versus triggers

2020-03-09 Thread Achilleas Mantzios
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 d

Re: Rules versus triggers

2020-03-07 Thread Justin
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 -05

Re: Rules versus triggers

2020-03-07 Thread stan
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 event

Re: Rules versus triggers

2020-03-07 Thread Justin
Sat, Mar 7, 2020 at 6:56 AM 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 becaus

Re: Rules versus triggers

2020-03-07 Thread Steve Atkins
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

Rules versus triggers

2020-03-07 Thread stan
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