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