On Wed, Oct 23, 2019 at 12:01 PM Stuart McGraw <smcg4...@mtneva.com> wrote:
> When examples are given, they typically are with scalar values where > such behavior makes sense: the resulting scalar value has to be NULL > or non-NULL, it can't be both. > > It is less sensible with compound values where the rule can apply to > individual scalar components. And indeed that is what Postgresql does > for another compound type: > I agree completely. Scalar vs compound structure seems like the essential difference. You don't expect an operation on an element of a compound structure to be able to effect the entire structure. Maurice