Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hVDsy-00055Z-AT for pgsql-docs@arkaria.postgresql.org; Mon, 27 May 2019 11:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hVDsw-0001TR-4l for pgsql-docs@arkaria.postgresql.org; Mon, 27 May 2019 11:33:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hVDsu-0001TK-QD for pgsql-docs@lists.postgresql.org; Mon, 27 May 2019 11:33:45 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hVDsq-0004oo-QI for pgsql-docs@lists.postgresql.org; Mon, 27 May 2019 11:33:43 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id A63272217D; Mon, 27 May 2019 07:33:39 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute7.internal (MEProxy); Mon, 27 May 2019 07:33:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=ovta93 A7AHw9qP765Jmrgwqcl1yDa4H+ifFSqvi/Sgw=; b=BOQTxPoMNUmPNGzIwD+OWe JVQ6zHUTZ0rEAWTrfvBsrm8NvOMHrNHWRf48QfMrAQOHEIHcTpHzjS3wtwvtoHnP WseD+HnLIwII/tj/ajmZdh8OvN9RZFI8BVRC0kq5gof4imD2AmA6F7aERKXFdIIn l0xnbmGWdwTibecqf6s03Z8K4TWvDUQsleIQ0cXXom8DEcflK4gKNFbUj+Vs1t9p vK/PDlUy8O0x878zv1eJFFKZrpiyWeP6v3/VtGi3joit8Nr9Z9tLA+W1bYt2Uz+o +d+zZMKfHoM9RODBTqVjUZjoQT3uDbuCVpyj0ef8wGfntKI8cV/wh611sDBuGB+g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddruddvvddggedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgesmhdtreertdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh hurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdrtgho mhenucfkphepkeekrdduvdekrdektddrheegnecurfgrrhgrmhepmhgrihhlfhhrohhmpe hpvghtvghrrdgvihhsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomhenucev lhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from april.pezone.net (unknown [88.128.80.54]) by mail.messagingengine.com (Postfix) with ESMTPA id EC91D38008B; Mon, 27 May 2019 07:33:37 -0400 (EDT) Subject: Re: SQL-2016 in docs To: Oleg Bartunov , pgsql-docs@lists.postgresql.org References: From: Peter Eisentraut Openpgp: preference=signencrypt Autocrypt: addr=peter.eisentraut@2ndquadrant.com; prefer-encrypt=mutual; keydata= xsFNBFUUt6kBEADZd9NNTBJbHmAXXJgPGOdd6Q73l80oifIVgn2tRxP9dYkCfTlo/yLqbKTl JNqTcyM6XrJDnB2sMEUGYCewYZXl+9C4bBJWyNqcEI1ae9u71vEq/fknFLArJ+2wN+f7QuRx Q8d94ZJAiJQ5g3fNk2HVeedCQCKP5dCzU+ZLt2dbsx1PDZLjTO9gf+JswWuGFb5wY5PZVM5V hq66Xk7ZJzHuARacza2RT7J2fkMmQBY+kr7L98Perb0GhafnlhXB0PvUB+N3xpmggMfwuhTu BngS/G/r3GvemxJuFxouw8xsMqrsfdksJXA2gLXYtwRCssdPV3PO0rlD9twqDo8URfIJ5fb6 1g/MV8aTOKjg3Q8MpJPtkwJqN4o3PvbwYdedeFnOVkkYAJdu/aX1v1BeCBDu7Hy3sF52scD3 pQbyQSl9vUDpTLarASAxNbAV0NRJE8dp4vfW6AH1ccryGiFqw/czPK/iN0+MT8wsjAW6WW4w hvjm5UPA1KTwi3ZT8eT5uycuH7QpuNk7LnGGXQ6KaRALFywzkr0A0V0AvFNa+l4wstMaXaB6 dmMXyF0/hfryqyOeu1gAdq4q0/PNC2dPgb/6uoh4eMjN6A5GXcprilhz5DulmsilY21hfSoU S64ODed96pKhprsOxjZiDRsN1QM5MwB+uwVWUNfsX7fIxE0BrwARAQABzSdQZXRlciBFaXNl bnRyYXV0IDxwZXRlckBlaXNlbnRyYXV0Lm9yZz7CwXoEEwEIACQCGwMFCwkIBwMFFQoJCAsF FgIDAQACHgECF4AFAlUUuKQCGQEACgkQoZ8SQ+xBJp8llw//RbGoXnF72FZTlOFsnNyxnWbF vViPCfdAlZl1GGK9OYCvV1dp/956HuhB0wpaGQHiBmQfOPJf/jLOPjXFYm2iEChEycrBChuE j4TSYemMp5BSPILYk9Uwd16kVD/+U6fQfK6H5pOhfBvbM6asMnmpY2wQuvktxHvaGlytFw84 EzFWNZtAZfxkw28w3AhIQkKe9hJanfyDL750RcbyEr8AAHty5IErrvS7tM5vQwIeh5BF26ND CyKPRdZgOgMpcwFfROKBDpAt052CgWIpNdhBdfIKlkCs4/ILxmC3rT/Mb/qZiHcoMMwEu6k+ T7vRAFZZAk62Yrr/U8/vUGKlzRZQoo86fyojCfI0ibCIc0z8rwCVY9P40G9wD9BTCZS/z8Vh jjpBlNnIKw2hM6hbxavKndCJjFFJD08rXrTyrLF/of18xD37vNdYooP9VATB5QjOWFRrscSZ 4a89e+to3m7YVnd4xdXwGp47dYusoax84C8tg1gZrH38ol9dPmnKX6GZrXeS7tH9k8VeUpJ8 HQbRThQRWAT936QpYbLConBmOtmbLmjQOGtiXPo1oK57X/7U/WBja5vWmm2q+Yxtt+3uHGVg DdDU4CJpXo4lX0v2n3QV5EBSW9hjdF3bNfl6GFBb1pPEhqNcMDUc7zkx/2uENdAdk/BnqMgH umip7b0pVfvOwU0EVRS3qQEQAJf6p0P7D+hMYUgCPkvgrcz6OJYsAYdUMUmokfqmkKwK0oJM ew8TNGM53ocKAgQGma5f10rwbZNPlpVPNRX5hwUmwVlcwSut0oE+JfUBH7mpysWvpF05RKIy q9RCoJZrAbXS7Tig56A1QD8IcM00rERZMcCOlI1+q9m4u9AOI+0LyGGSH+VvoyDHD/Jew4R2 TmPEF8Pu7lYiNYK88Q6u0kBkc+Tz3BNlyc6fi3HxnFfp0b75HLXPSTu2SwA/0Q31wHZXwrEU BR9KgSn/qbgy8ydPc97i82fhiFE3cbGexfPrQSMYmDGi+dcQ0s+AMQwC3XyMC0JkHpYUuFkR QdlIvaIhgFUUN2Vr4xF2ADaNTNFc4DYaiPHFAgHZw+3pZWqS4uIiWgJynrEaHw4F3QWU8/JB iyEWDhNq4WBrRA0u914TCCAoFOOKMnRdl8eJrRQKM/5/lXbHFjjlI/LDKhLRFsuQsnJJ3331 RjCzpHPZG5/p5KR1RHiAXa0p/DW5lXyq21hS3kjDlleoHqOxCN/cy0Jgz7qLDq1vZoCl67Sy RAH60c2Xu4may9SVltmot0OzWVHdrfS+85FQGp9580DaeLio7YMFKy2bfEvwQJ/c9xD2QPB+ oSb3V8ueSznXBG5+dyfOsZFRPxceA0wA2rSWZSjxLdKxvyGTj9vsCjaDu13rABEBAAHCwV8E GAEIAAkFAlUUt6kCGwwACgkQoZ8SQ+xBJp+HJhAAxmSTsC5y7p9Zu+nnLpucv/h88oEx985e qWeXzQiwM3pfRZS+PdTH9TyzHK0KOgKoAiubk0vt+BrT91D9d0G5kVQaTctAErGBoMkTaZJT XVEcNphiPzysdSqvprjojMp1y7rG8AP+Xd6m0rE1LRnkRRm8HyI8vdXsuLQPITGWXDLMjaNq AOV3BUnzkgtjMuIYw7SCr+12ZOb5dEKvaG4kjC4kaJ/TLbuBhVANcXkC90yp0AOZLs/cB1Dj OAXno/RUUruJ3r27a+pFv768UAi9QWcdw58yPxreMNMLqAgsS9oTHwHfGNWcB2dJ4UW+GMLJ hTf9TjQ2f+N/sIx5XMQ9pYw6CAJMK29qPx6/ZayrPxf22EXf0D3zTwIEZgwfSkynFVwV25L7 awQq60fifdMYheSxq7GbhpsixmcD+e161cCmLIt75YDt5bQ0B1yf7EmxG8n7pGZAOM6LoNsU fkSldba5XVwh8LuN5mK0nQBELGW6Os4TDq4REggLpfcvFC215zpuo0iCGnmE/Bns4nowqUSP u4tkWL+nxW4qgv8wo8HJ52jd79EJ8iqfIBoidBfy9AIUiEUApGQzWPu6yWcI8fY0rN5D+tc+ Yw1Zt6Mm+huYJpgCRsTcfzEcahnBn521CWcWvhW1ff3KFileFMtNmnBBhMncmRKHphtTKEpN 3jI= Organization: 2ndQuadrant Message-ID: Date: Mon, 27 May 2019 13:33:36 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/mixed; boundary="------------925A6E17B58624EF6542A8CC" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------925A6E17B58624EF6542A8CC Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit On 2019-05-12 10:14, Oleg Bartunov wrote: > I noticed that in our docs for PG12 there is no SQL-2016, but we actually > have JSON Path implementation committed, which is a part of SQL-2016 > standard. One missing feature - is datetime support. Peter, will you > add this or I prepare the patch ? I did a rough check of the SQL:2016 JSON path specification versus our regression tests, and came up with the attached supported feature list. Would you like to confirm it? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --------------925A6E17B58624EF6542A8CC Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0001-Update-SQL-conformance-information-about-JSON-path.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename*0="0001-Update-SQL-conformance-information-about-JSON-path.patc"; filename*1="h" RnJvbSBmYmE4NWM3NDVmNGU4NGRhMzY5YzYyM2I1MThmY2JmMDcxODk5OGYwIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogTW9uLCAyNyBNYXkgMjAxOSAxMjowNToxOCArMDIwMApTdWJqZWN0 OiBbUEFUQ0hdIFVwZGF0ZSBTUUwgY29uZm9ybWFuY2UgaW5mb3JtYXRpb24gYWJvdXQgSlNP TiBwYXRoCgotLS0KIHNyYy9iYWNrZW5kL2NhdGFsb2cvc3FsX2ZlYXR1cmVzLnR4dCB8IDE0 ICsrKysrKystLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNyBpbnNlcnRpb25zKCspLCA3IGRl bGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvc3FsX2ZlYXR1 cmVzLnR4dCBiL3NyYy9iYWNrZW5kL2NhdGFsb2cvc3FsX2ZlYXR1cmVzLnR4dAppbmRleCA2 OGRhMThiM2JjLi5hZTg3NGYzOGVlIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9jYXRhbG9n L3NxbF9mZWF0dXJlcy50eHQKKysrIGIvc3JjL2JhY2tlbmQvY2F0YWxvZy9zcWxfZmVhdHVy ZXMudHh0CkBAIC01NDMsMTMgKzU0MywxMyBAQCBUODI3CUpTT05fVEFCTEU6IHNpYmxpbmcg TkVTVEVEIENPTFVNTlMgY2xhdXNlcwkJCU5PCiBUODI4CUpTT05fUVVFUlkJCQlOTwkKIFQ4 MjkJSlNPTl9RVUVSWTogYXJyYXkgd3JhcHBlciBvcHRpb25zCQkJTk8JCiBUODMwCUVuZm9y Y2luZyB1bmlxdWUga2V5cyBpbiBTUUwvSlNPTiBjb25zdHJ1Y3RvciBmdW5jdGlvbnMJCQlO TwkKLVQ4MzEJU1FML0pTT04gcGF0aCBsYW5ndWFnZTogc3RyaWN0IG1vZGUJCQlOTwkKLVQ4 MzIJU1FML0pTT04gcGF0aCBsYW5ndWFnZTogaXRlbSBtZXRob2QJCQlOTwkKLVQ4MzMJU1FM L0pTT04gcGF0aCBsYW5ndWFnZTogbXVsdGlwbGUgc3Vic2NyaXB0cwkJCU5PCQotVDgzNAlT UUwvSlNPTiBwYXRoIGxhbmd1YWdlOiB3aWxkY2FyZCBtZW1iZXIgYWNjZXNzb3IJCQlOTwkK LVQ4MzUJU1FML0pTT04gcGF0aCBsYW5ndWFnZTogZmlsdGVyIGV4cHJlc3Npb25zCQkJTk8J Ci1UODM2CVNRTC9KU09OIHBhdGggbGFuZ3VhZ2U6IHN0YXJ0cyB3aXRoIHByZWRpY2F0ZQkJ CU5PCQotVDgzNwlTUUwvSlNPTiBwYXRoIGxhbmd1YWdlOiByZWdleF9saWtlIHByZWRpY2F0 ZQkJCU5PCQorVDgzMQlTUUwvSlNPTiBwYXRoIGxhbmd1YWdlOiBzdHJpY3QgbW9kZQkJCVlF UwkKK1Q4MzIJU1FML0pTT04gcGF0aCBsYW5ndWFnZTogaXRlbSBtZXRob2QJCQlOTwlkYXRl dGltZSgpIG5vdCB5ZXQgaW1wbGVtZW50ZWQKK1Q4MzMJU1FML0pTT04gcGF0aCBsYW5ndWFn ZTogbXVsdGlwbGUgc3Vic2NyaXB0cwkJCVlFUwkKK1Q4MzQJU1FML0pTT04gcGF0aCBsYW5n dWFnZTogd2lsZGNhcmQgbWVtYmVyIGFjY2Vzc29yCQkJWUVTCQorVDgzNQlTUUwvSlNPTiBw YXRoIGxhbmd1YWdlOiBmaWx0ZXIgZXhwcmVzc2lvbnMJCQlZRVMJCitUODM2CVNRTC9KU09O IHBhdGggbGFuZ3VhZ2U6IHN0YXJ0cyB3aXRoIHByZWRpY2F0ZQkJCVlFUwkKK1Q4MzcJU1FM L0pTT04gcGF0aCBsYW5ndWFnZTogcmVnZXhfbGlrZSBwcmVkaWNhdGUJCQlZRVMJCiBUODM4 CUpTT05fVEFCTEU6IFBMQU4gREVGQVVMVCBjbGF1c2UJCQlOTwkKIFQ4MzkJRm9ybWF0dGVk IGNhc3Qgb2YgZGF0ZXRpbWVzIHRvL2Zyb20gY2hhcmFjdGVyIHN0cmluZ3MJCQlOTwkKIE0w MDEJRGF0YWxpbmtzCQkJTk8JCi0tIAoyLjIxLjAKCg== --------------925A6E17B58624EF6542A8CC--