Re: RULE does not like the NOT EXISTS condition

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Szima Gábor <sygma(at)tesla(dot)hu>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RULE does not like the NOT EXISTS condition
Date: 2018-09-08 17:52:19
Message-ID: 87ftyjswry.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "Andrew" == Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
>>>>> "Szima" == Szima Gábor <sygma(at)tesla(dot)hu> writes:

Szima> Hi!
Szima> I found an "interest" in RULE's operation:

Andrew> All non-trivial* rules are wrong,

I should of course add: the solution is to use triggers instead, which
are much easier to understand and have very predictable behavior.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-09-08 19:25:29 Re: remove duplicated words in comments .. across lines
Previous Message Andrew Gierth 2018-09-08 16:10:59 Re: RULE does not like the NOT EXISTS condition