Dne 28. 11. 2016 17:26 napsal uživatel "David Fetter" <da...@fetter.org>: > > On Sun, Nov 27, 2016 at 11:50:30AM -0500, Christian Convey wrote: > > >From looking at other databases' docs, it seems like the behavior of > > various JSON-related operators / functions are described partially in terms > > of a "json path expression": > > > > * In Oracle, "JSON_TABLE", "JSON_exists_column", "JSON_value_column": [1] > > * In MySQL: [2] > > * In DB2: [3] > > * In MS SQL Server: [4] > > * (Whatever the Standards committee will end up producing.) > > There's another option we should also consider: jq > <https://stedolan.github.io/jq/>. It's available under a > PostgreSQL-compatible license, and has had a LOT of work put into > correctness and performance.
we can use it for inspiration. but the syntax of this tool is little bit too complex and too original against Json path ... jsonpath is relative simple implementation of xpath to json we have one proprietary syntax already, two is maybe too much :-) > > Best, > David. > -- > David Fetter <david(at)fetter(dot)org> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate