Typo in DATATYPE-JSONPATH
От | PG Doc comments form |
---|---|
Тема | Typo in DATATYPE-JSONPATH |
Дата | |
Msg-id | 161851706474.691.5311470676483994129@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: Typo in DATATYPE-JSONPATH
|
Список | pgsql-docs |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-json.html Description: Hello, On the DATATYPE-JSONPATH page: https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH There is a line that shows that GIN indexes support `@@` and `@?` operators for json matching, then there are two examples trying to show both operators. However both examples use the `@@` operator. Examples from the doc: SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] == "qui"'; SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] ? (@ == "qui")'; I think the second example should be using the `@?` operator so that both sample queries do the same thing but with the different operator types. So the second example should read: SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @? '$.tags[*] ? (@ == "qui")'; Thank you, Ben
В списке pgsql-docs по дате отправления: