Re: SQL/JSON documentation JSON_TABLE

2022-07-15 Thread Andrew Dunstan
On 2022-07-15 Fr 02:20, Erik Rijkers wrote: > On 7/14/22 17:45, Andrew Dunstan wrote: >> >> >> Here's a patch that deals with most of this. There's one change you >> wanted that I don't think is correct, which I omitted. >> >> [json-docs-fix.patch] > > Thanks, much better. I also agree that the c

Re: SQL/JSON documentation JSON_TABLE

2022-07-14 Thread Erik Rijkers
On 7/14/22 17:45, Andrew Dunstan wrote: On 2022-07-08 Fr 16:20, Andrew Dunstan wrote: On 2022-07-08 Fr 16:03, Erik Rijkers wrote: Hi, Attached are a few small changes to the JSON_TABLE section in func.sgml. The first two changes are simple typos. Then there was this line: context_item

Re: SQL/JSON documentation JSON_TABLE

2022-07-14 Thread Andrew Dunstan
On 2022-07-08 Fr 16:20, Andrew Dunstan wrote: > On 2022-07-08 Fr 16:03, Erik Rijkers wrote: >> Hi, >> >> Attached are a few small changes to the JSON_TABLE section in func.sgml. >> >> The first two changes are simple typos. >> >> Then there was this line: >> >> >> context_item, path_expressio

Re: SQL/JSON documentation JSON_TABLE

2022-07-08 Thread Andrew Dunstan
On 2022-07-08 Fr 16:03, Erik Rijkers wrote: > Hi, > > Attached are a few small changes to the JSON_TABLE section in func.sgml. > > The first two changes are simple typos. > > Then there was this line: > > > context_item, path_expression [ AS json_path_name ] [ PASSING { value > AS varname }

SQL/JSON documentation JSON_TABLE

2022-07-08 Thread Erik Rijkers
Hi, Attached are a few small changes to the JSON_TABLE section in func.sgml. The first two changes are simple typos. Then there was this line: context_item, path_expression [ AS json_path_name ] [ PASSING { value AS varname } [, ...]] those are the parameters to JSON_TABLE() so I

Re: SQL/JSON: documentation

2019-02-03 Thread Michael Paquier
On Mon, Dec 03, 2018 at 07:23:09PM +0300, Liudmila Mantrova wrote: > Unfortunately, I couldn't find much time for this activity, but as far as I > understand, thread [1] only requires jsonpath documentation right now. So I > extracted the relevant parts from this patch, reworked path expression > d

Re: SQL/JSON: documentation

2018-12-03 Thread Liudmila Mantrova
On 11/29/18 7:34 PM, Dmitry Dolgov wrote: Hi, Any progress on that? It would be nice to have a new version of the documentation, and I would even advocate to put it into the json path patch [1] (especially, since there were already requests for that, and I personally don't see any reason to keep

Re: SQL/JSON: documentation

2018-11-29 Thread Dmitry Dolgov
> On Mon, Oct 1, 2018 at 2:24 PM Liudmila Mantrova > wrote: > > We'll continue working with Nikita and Oleg to improve the > content before we resend an updated patch; I believe we might still need > a separate source file if we end up having a separate chapter with usage > examples and implement

Re: SQL/JSON: documentation

2018-10-01 Thread Liudmila Mantrova
On 09/28/2018 08:29 PM, Peter Eisentraut wrote: On 28/06/2018 01:36, Nikita Glukhov wrote: Attached patch with draft of SQL/JSON documentation written by Liudmila Mantrova, Oleg Bartunov and me. Also it can be found in our sqljson repository on sqljson_doc branch: https://github.com

Re: SQL/JSON: documentation

2018-09-28 Thread Tom Lane
Andrew Dunstan writes: > On 09/28/2018 01:29 PM, Peter Eisentraut wrote: >> - I don't think this should be moved to a separate file. Yes, func.sgml >> is pretty big, but if we're going to split it up, we should do it in a >> systematic way, not just one section. > I'm in favor of doing that. It'

Re: SQL/JSON: documentation

2018-09-28 Thread Andrew Dunstan
On 09/28/2018 01:29 PM, Peter Eisentraut wrote: On 28/06/2018 01:36, Nikita Glukhov wrote: Attached patch with draft of SQL/JSON documentation written by Liudmila Mantrova, Oleg Bartunov and me. Also it can be found in our sqljson repository on sqljson_doc branch: https://github.com

Re: SQL/JSON: documentation

2018-09-28 Thread Peter Eisentraut
On 28/06/2018 01:36, Nikita Glukhov wrote: > Attached patch with draft of SQL/JSON documentation written by > Liudmila Mantrova, Oleg Bartunov and me. > > Also it can be found in our sqljson repository on sqljson_doc branch: > https://github.com/postgrespro/sqljson/tree/sqlj

Re: SQL/JSON: documentation

2018-06-28 Thread Chapman Flack
On 06/28/2018 06:45 PM, Nikita Glukhov wrote: > Standard says only about returning of string (both binary and character), > numeric, boolean and datetime types in JSON_VALUE and only about string > types in JSON_QUERY. What I think I noticed was that right now, in func-sqljson.sgml, the same list

Re: SQL/JSON: documentation

2018-06-28 Thread Nikita Glukhov
On 28.06.2018 05:23, Chapman Flack wrote: On 06/27/2018 07:36 PM, Nikita Glukhov wrote: Also it can be found in our sqljson repository on sqljson_doc branch: https://github.com/postgrespro/sqljson/tree/sqljson_doc Perhaps it is my unfamiliarity, but it seems that on lines 1067–1071, the outpu

Re: SQL/JSON: documentation

2018-06-27 Thread Chapman Flack
On 06/27/2018 07:36 PM, Nikita Glukhov wrote: > Also it can be found in our sqljson repository on sqljson_doc branch: > https://github.com/postgrespro/sqljson/tree/sqljson_doc Perhaps it is my unfamiliarity, but it seems that on lines 1067–1071, the output clause for JSON_VALUE is given support f