ИСТИНА

PostgreSQL 12 introduced a jsonpath - the query language for json, which is an important part of SQL/JSON specification in SQL-2016 standard. Jsonpath is a flexible way to specify the parts of json to be used for processing in functions and operators. The language being very rich is quite complex and we will demonstrate how it works using examples from simple to complex quieries. Also, we will explain how indexes works for jsonpath and show the performance benefits of using jsonpath and old arrow operators. We will present the roadmap for PostgreSQL 13 and further releases.