Postgres Pro
Downloads
Home   >   mailing lists

Re: RULE does not like the NOT EXISTS condition - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: RULE does not like the NOT EXISTS condition
Date
Msg-id 87ftyjswry.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to RULE does not like the NOT EXISTS condition  (Szima Gábor <sygma@tesla.hu>)
List pgsql-hackers
Tree view 
>>>>> "Andrew" == Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>>>>> "Szima" == Szima Gábor <sygma@tesla.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)

pgsql-hackers by date:

Previous
From: Szima Gábor
Date:
Subject: RULE does not like the NOT EXISTS condition
Next
From: Michael Paquier
Date:
Subject: Re: remove duplicated words in comments .. across lines