search

postgres-cn / pgdoc-cn

PostgreSQL manual Chinese translation by China PostgreSQL Users Group
http://www.postgres.cn/docs
Other
1.8k stars 402 forks source link

Update json.sgml #347

Closed 16638112210 closed 3 years ago

16638112210 commented 3 years ago

这个符号是否标错了

oneofsunshine commented 3 years ago

我确认了一下, 应该没标错吧

<programlisting>
SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] == "qui"';
</programlisting>
<programlisting>
SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] ? (@ == "qui")';
</programlisting>
ChenHuajun commented 3 years ago

这是PG英文手册本身的BUG，现已修复。 https://github.com/postgres/postgres/commit/254a2164e5b216ecf98882f8bcb9e239ab2d432d

原则上这版的PG13中文手册应该以PG13.1英文手册为基准，但为了避免这个bug带来的麻烦，提前合并进来，同时反映到PG12。