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 по дате отправления: