Re: Doc Rework: Section 9.16.13 SQL/JSON Query Functions - Mailing list pgsql-hackers

From jian he
Subject Re: Doc Rework: Section 9.16.13 SQL/JSON Query Functions
Date
Msg-id CACJufxFGXnx6At9=8gcxXuFSnDizEojpXSP76JAukGcujtEzeA@mail.gmail.com
Whole thread Raw
In response to Re: Doc Rework: Section 9.16.13 SQL/JSON Query Functions  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
another tiny issue.

-        <literal>select json_query(jsonb '{"a": "[1, 2]"}', 'lax $.a'
OMIT QUOTES);</literal>
+        <literal>JSON_QUERY(jsonb '{"a": "[1, 2]"}', 'lax $.a' OMIT
QUOTES);</literal>
         <returnvalue>[1, 2]</returnvalue>
        </para>
        <para>
-        <literal>select json_query(jsonb '{"a": "[1, 2]"}', 'lax $.a'
RETURNING int[] OMIT QUOTES ERROR ON ERROR);</literal>
+        <literal>JSON_QUERY(jsonb '{"a": "[1, 2]"}', 'lax $.a'
RETURNING int[] OMIT QUOTES ERROR ON ERROR);</literal>

These two example queries don't need semicolons at the end?



pgsql-hackers by date:

Previous
From: "杨伯宇(长堂)"
Date:
Subject: 回复:Re: 回复:Re: speed up pg_upgrade with large number of tables
Next
From: Peter Smith
Date:
Subject: Re: Pgoutput not capturing the generated columns