History of 2021-09-13 A gotcha with PostgreSQL's jsonb type

2021-09-13
16:18 UTC Revision 1 . . . . mborkAs you may probably know, I am a big fan of PostgreSQL. That doesn’t mean that it’s always easy for me to use or intuitive, though. Today I ran into something strange (which is not that strange when you think of it, but still). Consider a table with a jsonb field, which sometimes has some key and sometimes not (which is the main point of having a jsonb field after all)