logoalt Hacker News

renhanxueyesterday at 12:53 AM1 replyview on HN

If you, for whatever obscure reason, need to preserve whitespace and key ordering, that is you want something that is effectively just a text column, then you should use JSON over JSONB.

I can't think of any case at all, no matter how contrived, where you'd want to use the non-B versions of the JSON aggregate functions though.


Replies

paulryanrogersyesterday at 1:25 AM

The non-B JSON can take up less space on disk and less write time complexity.

show 1 reply