Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WyR1a-0005PG-Nt for pgsql-docs@arkaria.postgresql.org; Sat, 21 Jun 2014 19:32:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WyR1Z-00086F-Cb for pgsql-docs@arkaria.postgresql.org; Sat, 21 Jun 2014 19:32:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WyR1X-000866-GY for pgsql-docs@postgresql.org; Sat, 21 Jun 2014 19:32:27 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WyR1T-0007sE-GF for pgsql-docs@postgresql.org; Sat, 21 Jun 2014 19:32:26 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1WyR1Q-0006QK-7e; Sat, 21 Jun 2014 15:32:20 -0400 Date: Sat, 21 Jun 2014 15:32:20 -0400 From: Bruce Momjian To: Tom Lane Cc: PostgreSQL-documentation Subject: Re: JSON doc problem Message-ID: <20140621193220.GA6198@momjian.us> References: <20140621041844.GA19251@momjian.us> <13007.1403364760@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="KsGdsel6WgEHnImy" Content-Disposition: inline In-Reply-To: <13007.1403364760@sss.pgh.pa.us> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --KsGdsel6WgEHnImy Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Jun 21, 2014 at 11:32:40AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > What does this "But" refer to, and it is consistent with the sentences above? > > Hmm. Probably "Also" or "Moreover" would work there. I think this might > be leftover from a previous version of the paragraph --- I recall having > rewritten that several times before I was satisfied with it. Thanks. I have adjusted it with the attached, applied patch. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + --KsGdsel6WgEHnImy Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="json.diff" diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml new file mode 100644 index 6642618..d55a08f *** a/doc/src/sgml/json.sgml --- b/doc/src/sgml/json.sgml *************** SELECT jdoc->'guid', jdoc->'name' *** 460,470 **** and a jsonb_path_ops GIN index is that the former creates independent index items for each key and value in the data, while the latter creates index items only for each value in the ! data.For this purpose, the term value ! includes array elements, though JSON terminology sometimes considers ! array elements distinct from values within objects. ! But in jsonb_path_ops, each index item is a hash ! of both the value and the key(s) leading to it; for example to index {"foo": {"bar": "baz"}}, a single index item would be created incorporating all three of foo, bar, and baz into the hash value. Thus a containment query --- 460,475 ---- and a jsonb_path_ops GIN index is that the former creates independent index items for each key and value in the data, while the latter creates index items only for each value in the ! data. ! ! ! For this purpose, the term value includes array elements, ! though JSON terminology sometimes considers array elements distinct ! from values within objects. ! ! ! Basically, each jsonb_path_ops index item is ! a hash of the value and the key(s) leading to it; for example to index {"foo": {"bar": "baz"}}, a single index item would be created incorporating all three of foo, bar, and baz into the hash value. Thus a containment query --KsGdsel6WgEHnImy Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --KsGdsel6WgEHnImy--