Databases: jsonb_array_elements() in the select seems to turn a left join into an inner join
Even JSONB In Postgres Needs Schemas | POSETTE 2024
JSONB 関数、演算子、使用例
JSON[b] Roadmap - Oleg Bartunov: PGCon 2020
ボリス・メヒアス。 PostgreSQL の JSON - ケーススタディで学ぶ // #PostgresTV #PostgresOpenTalks
Postgres vs Mongo / Олег Бартунов (Postgres Professional)
Advanced SQL — Chapter #03 — Video #20 — JSON support (type jsonb) [and XML support]
HOW TO QUERY NESTED JSON: USING PYTHON TO POSTGRESQL with (psycopg2)
2022-04-13: FTS/working with JSONB/GIN Index
SQL/JSON: реализуем стандарт и не останавливаемся на этом / Александр Коротков
PGConfRu2019 Oleg Bartunov, Alexander Korotkov - «What should we expect from PostgreSQL 12?»
== あらゆる規模の Citus PostgreSQL ==