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 1hD2uo-00035h-IY for pgsql-docs@arkaria.postgresql.org; Sun, 07 Apr 2019 08:12:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hD2un-0005qo-6p for pgsql-docs@arkaria.postgresql.org; Sun, 07 Apr 2019 08:12:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hCqXy-0002bk-UD for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 19:00:10 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hCqXu-00023D-Sl for pgsql-docs@lists.postgresql.org; Sat, 06 Apr 2019 19:00:10 +0000 Content-Type: multipart/mixed; boundary="===============1067625794374934523==" MIME-Version: 1.0 Subject: How to query the underlying dictionary i.e. inverse of ts_lexize() To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: postgresql@richardneill.org Reply-To: postgresql@richardneill.org, pgsql-docs@lists.postgresql.org Date: Sat, 06 Apr 2019 18:59:27 +0000 Message-ID: <155457716793.719.16452998626279741513@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1067625794374934523== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMS90ZXh0 c2VhcmNoLWRlYnVnZ2luZy5odG1sCkRlc2NyaXB0aW9uOgoKSXQgd291bGQgYmUgaGVscGZ1bCBp ZiB0aGVyZSB3ZXJlIHNvbWUgZG9jdW1lbnRhdGlvbiBvbiBob3cgdG8gcXVlcnkgdGhlCmRpY3Rp b25hcmllcyB0aGVtc2VsdmVzLCB0byBnZXQgYSBjYW5vbmljYWwgcm9vdCB3b3JkLCBlaXRoZXIu DQoNCjEuIERpcmVjdGx5LCBzdWNoIGFzOg0KICAiU0VMRUNUIHdvcmRzIEZST00gZW5nbGlzaF9z dGVtIFdIRVJFIHN0ZW0gPSAnY2hsb3JpbicNCiAtLSBzaG91bGQgcmV0dXJuIGUuZy4gImNobG9y aW5lIiwgImNobG9yaW5hdGlvbiIsICJjaGxvcmluYXRlZCINCiAtLSB0aGVyZSBpc24ndCBhbnkg ZG9jdW1lbnRhdGlvbiBvbiBob3cgdG8gYWN0dWFsbHkgZG8gdGhpcy4NCg0KMi4gSW5kaXJlY3Rs eSwgc3VjaCBhczoNCiAiU0VMRUNUIHRzX3VubGV4aXplKCdlbmdsaXNoX3N0ZW0nLCdjaGxvcmlu Jyk7ICANCi0tIHRoaXMgaXMgYSBmdW5jdGlvbiB3aGljaCBkb2Vzbid0IHlldCBzZWVtIHRvIGV4 aXN0OiB0aGUgb25lLXRvLW1hbnkKaW52ZXJzZSBvZiB0c19sZXhpemUoKS4NCg0KMy4gT3IsIHRo ZSBjYW5vbmljYWwgdmVyc2lvbiBvZiAoMikuDQoiU0VMRUNUIHRzX2Nhbm9uaWNhbCgnZW5nbGlz aF9zdGVtJywnY2hsb3JpbicpOw0KLS1hIG9uZSB0byBvbmUgZnVuY3Rpb24gdG8gZmluZCB0aGUg ZW5nbGlzaCByb290IHdvcmQgKG5vdCB0aGUgbGV4ZW1lKS4NCg0KQW4gZXhhbXBsZSBvZiB3aGVy ZSB0aGlzIGlzIHVzZWZ1bDogY29uc2lkZXIgYSBsaXN0IG9mIGRvY3VtZW50cywgY29udGFpbmlu ZwphIGxhcmdlIGFtb3VudCBvZiBlbmdsaXNoIHRleHQuIA0KRm9yIHRoaXMgZXhhbXBsZSwgY29u c2lkZXIgdGhhdCB0aGUgZm9sbG93aW5nIHdvcmRzIGFyZSBmcmVxdWVudDogInRoZSIsCiJraXR0 ZW4iLCAia2l0dGVucyIsICJjaGxvcmluYXRpb24iLCAiY2hsb3JpbmF0ZWQiLCAidGVtcGVyYXR1 cmUiIGFuZAoic29tZXRoaW5nIi4NCg0KV2Ugd2lzaCB0byBkaXNwbGF5IGEgInRhZyBjbG91ZCIg b2YgdGhlIG1vc3QgY29tbW9uIHRlcm1zLCBleGNsdWRpbmcKc3RvcHdvcmRzLCBieSBtZWFucyBv ZiB0c19zdGF0KCkuICANCkF0IHRoZSBtb21lbnQsIGl0IGxpc3RzOiANCiAgImtpdHRlbiIgICAg ICAgICAgLS0gY29ycmVjdGx5IHRyZWF0aW5nICJraXR0ZW4iIGFuZCAia2l0dGVucyIgYXMgdGhl CnNhbWUuDQogICJjaGxvcmluIiAgICAgICAgLS0gY29ycmVjdGx5IG1lcmdpbmcgImNobG9yaW5h dGlvbiIgYW5kICJjaGxvcmluYXRlZCIsCmJ1dCBjcmVhdGluZyBhIG5vbi13b3JkLg0KICAidGVt cGVyYXR1ciIgIC0tIHJpZ2h0IHN0ZW0sIG5vdCBhIHdvcmQuDQogICJzb21ldGgiICAgICAgIC0t IG1pc3Rha2VuIHBhcnNlciwgaGFzIHJlbW92ZWQgdGhlIC1pbmcgc3VmZml4Lg0KDQpTbywgZ2l2 ZW4gdGhlIGFycmF5IFsia2l0dGVuIiwiY2hsb3JpbiIsInRlbXBlcmF0dXIiLCJzb21ldGgiXSwg d2Ugd2lzaCB0bwp1bi1zdGVtIHRvIGZpbmQgdGhlIGZpcnN0IHZhbGlkIGVuZ2xpc2ggd29yZCB3 aG9zZSBzdGVtIGlzIGluIHRoYXQgYXJyYXksCmkuZS4gDQogIFsia2l0dGVuIiwgImNobG9yaW5l IiwgInRlbXBlcmF0dXJlIiwgInNvbWV0aGluZyJdDQpOb3RlIHRoYXQgaXQgaXMgaW50ZW50aW9u YWwgdG8gcmV0cmlldmUgImNobG9yaW5lIiBldmVuIHRob3VnaCB0aGUgb3JpZ2luYWwKaW5wdXRz IHdlcmUgImNobG9yaW5hdGVkIiBhbmQgImNobG9yaW5hdGlvbiIsIGFuZCBkaWQgbm90IG5lY2Vz c2FyaWx5CmNvbnRhaW4gImNobG9yaW5lIl0gDQoNClRoZXJlIGRvZXNuJ3Qgc2VlbSB0byBiZSBh bnkgcHJvY2VzcyBmb3IgZG9pbmcgdGhpcy4gTm90IHN1cmUgd2hldGhlciB0aGlzCmlzIGp1c3Qg c29tZXRoaW5nIGZvciB0aGUgZG9jdW1lbnRhdGlvbiwgb3IgYW4gUkZFIGZvciAoMikuIFRoYW5r cyB2ZXJ5Cm11Y2guCg== --===============1067625794374934523==--