search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.87k stars 1.05k forks source link

[Docs] Document jsonb jsonpath @@, @? operators #12876

Open jasonyb opened 2 years ago

jasonyb commented 2 years ago

Description

jsonpath operators @@ and @? should be documented. Notice https://www.postgresql.org/docs/12/functions-json.html describes those operators and also has an entire section on jsonpath. Don't forget to tie in GIN as well.

Original discussion (while it lasts): https://yugabyte-db.slack.com/archives/CG0KQF0GG/p1655160905053909

Google Doc with a copy of the public Slack thread (accessible to anyone in the YB organization): https://docs.google.com/document/d/16kI3Ga9HKYs3vIVno9BhVp4x7ToQLd0AOKS_vYDs1II/

polarweasel commented 2 years ago

(Updated description with Google doc link)

theory commented 2 years ago

See also #5408 for the introduction of json path support and the relevant updates to Postgres's SGML docs.