On Wed, Oct 23, 2019 at 12:01 PM Stuart McGraw <smcg4191@xxxxxxxxxx> wrote: > Why the inconsistency between the array > type and json type? Are there any cases other than json where the entire > compound value is set to NULL as a result of one of its components being > NULL? That's a great point. It does look like hstore's delete / minus operator behaves like that, though: =# select 'a=>1,b=>2'::hstore - null; ?column? ---------- (1 row)
