>>>>> "Peter" == Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
Peter> The SQL standard seems clear
ha
hahaha
HAHAHAHAHAHA
(since when has the SQL standard ever been clear?)
SQL2016, 15.17 Execution of referential actions
10) If a non-null value of a referenced column RC in the referenced
table is updated to a value that is distinct from the current value
of RC, then,
[snip all the stuff about how ON UPDATE actions work]
does that "is distinct from" mean that IS DISTINCT FROM would be true,
or does it mean "is in some way distinguishable from"? Nothing I can see
in the spec suggests the latter.
--
Andrew (irc:RhodiumToad)