On Tue, 15 Nov 2022 18:32:24 +0100
hubert depesz lubaczewski <depesz@depesz.com> wrote:
> > But is there anything that hstore can that JSON cannot?
>
> It's faster for some things:
> https://www.depesz.com/2021/04/21/getting-value-from-dynamic-column-in-pl-pgsql-triggers/
Thanks for the URL, the difference is indeed quite large.
> And it can be trivially used to check for differences in update
> triggers:
> hstore(NEW) - hstore(OLD)
I didn't knew that (and it's not part of the official doc :/)
> It's "abusability" is lower thanks to lack of nesting.
Yeah, it is a problem as some specs can contain a list, I discovered
that last night - so jsonb it'll be.
Jean-Yves