available in the PostgreSQL distribution. 8.14. JSON Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the the same time, to provide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access unlike regular SQL arrays that start from 1. Numeric literals in SQL/JSON path expressions follow JavaScript rules, which are different from both SQL and JSON in some minor details. For example, SQL/JSON

PostgreSQL distribution. 8.14. JSON Types 193 Data Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the same time, to pro- vide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access unlike regular SQL arrays that start from 1. Numeric literals in SQL/JSON path expressions follow JavaScript rules, which are different from both SQL and JSON in some minor details. For example, SQL/JSON

PostgreSQL distribution. 8.14. JSON Types 190 Data Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the same time, to pro- vide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access unlike regular SQL arrays that start from 1. Numeric literals in SQL/JSON path expressions follow JavaScript rules, which are different from both SQL and JSON in some minor details. For example, SQL/JSON

available in the PostgreSQL distribution. 8.14. JSON Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the the same time, to provide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access unlike regular SQL arrays that start from 1. Numeric literals in SQL/JSON path expressions follow JavaScript rules, which are different from both SQL and JSON in some minor details. For example, SQL/JSON

available in the PostgreSQL distribution. 8.14. JSON Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71592. Such data can also be stored as text, but the the same time, to provide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: 180 Data Types • Dot (.) is used for member access. • Square brackets ([]) are of path expressions require string literals within them. These em- bedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be

available in the PostgreSQL distribution. 8.14. JSON Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71592. Such data can also be stored as text, but the same time, to pro- vide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access of path expressions require string literals within them. These embedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be

PostgreSQL distribution. 8.14. JSON Types 186 Data Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the same time, to pro- vide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access of path expressions require string literals within them. These embedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be

PostgreSQL distribution. 8.14. JSON Types 177 Data Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71594. Such data can also be stored as text, but the the same time, to provide a natural way of working with JSON data, SQL/JSON path syntax uses some JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access of path expressions require string literals within them. These em- bedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be

PostgreSQL distribution. 8.14. JSON Types 174 Data Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71592. Such data can also be stored as text, but the to provide a most natural way of working with JSON data, SQL/JSON path syntax uses some of the JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access of path expressions require string literals within them. These em- bedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be

PostgreSQL distribution. 184 Data Types 8.14. JSON Types JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 71592. Such data can also be stored as text, but the to provide a most natural way of working with JSON data, SQL/JSON path syntax uses some of the JavaScript conventions: • Dot (.) is used for member access. • Square brackets ([]) are used for array access of path expressions require string literals within them. These embedded string literals follow JavaScript/ECMAScript conventions: they must be surrounded by double quotes, and backslash escapes may be