Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouhCM-00065a-50 for pgsql-novice@arkaria.postgresql.org; Mon, 14 Nov 2022 21:40:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ouhCL-0005bZ-1A for pgsql-novice@arkaria.postgresql.org; Mon, 14 Nov 2022 21:40:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouhCK-0005bQ-Oo for pgsql-novice@lists.postgresql.org; Mon, 14 Nov 2022 21:40:56 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ouhCI-00024J-KF for pgsql-novice@lists.postgresql.org; Mon, 14 Nov 2022 21:40:56 +0000 Received: from mail.defcon1.lan ([93.15.31.113]) by mail.gmx.net (mrgmx105 [212.227.17.174]) with ESMTPSA (Nemesis) id 1M5wLT-1osDIV464h-007Wrs; Mon, 14 Nov 2022 22:40:53 +0100 Date: Mon, 14 Nov 2022 22:40:51 +0100 From: Bzzzz To: Laurenz Albe , pgsql-novice@lists.postgresql.org Subject: Re: hstore or jsonb ? Message-ID: <20221114224051.71f3d5b7@msi.defcon1.lan> In-Reply-To: References: <20221114155057.48406b86@msi.defcon1.lan> Organization: Anyone, anywhere but in banana demokratik republik of france or UERSS. Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:TZhPP3wpfjhKzK7v5Uw4cUwAqBY8LDhFdQm2ZROcaFggWiKjt1B erQjxKw+nbA8VVm2kPV+HvoJQpEJXwuI1nhFpoECqBiopjRge2Emre8Ih37H6j5mlYX9BzM wZMoD8xa4nIfwCXwwpJb1oPN9vS9XppwVquB54J4m1eVu1UbytK1HAPT7ak7QZgIlSkuIuX sMVn3/TvXxfH1Mz2/oYqw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:+RLM0cyFnro=;9t2YnqEQLz753OcTYx3Imoeuwdt wDXudvFFK0aZD2BB5uZtGU4XJqYBkD9H5l/L7yqTkLP6lAo6L919bGJ9Zuk6xd4HXPxls07j9 Bw03fLTiU3KiZXupDDS36UyS9RPGRz6C6j/CUhnz7TOC9LFdMnBf/jdMuIlF4Vl/AdCuE1CTV IiG6O6ca9Tj+ausE97Hhgnif5UDc0x+9CyIx3dLKlpa3QMtI/SGRD2W53B1nhx0mjWMdgK8zp QE1Yq1dPrR1wUnmd+qXM6S1x4kxiVkDtgAZiIEcqhXxZWl1lHClMbUhkmzsdUfUyXsIVFKSaS hwCIcuWb5eTUplGWW3+C54GyJ3OJqKMDc8WnX+JQKkZ8TD7qO0y2MRAu8iV/wVIzvxF/dev3j fuppLr2DeBsaWqP5CqcpztxOU6afDM2bWzifmgEVWBkmlmXlCL1b89jR+4xLcGHlv2h7vy1rD gcAHTo8jYeiFBWO0WX9XAERBbfHJrQZ/pLhh3xqtxaRlvzbEH/Q86Tm0UC2eQ2aUrnQrFzLTw Gxok2KzrKSU/DmvlgvtbkZ53Lx3oMVHFwhQOQmYi67q4oCAAcLJauWsjjruZfYdcJssJo+oA6 kD2jwy/DojSDxJtnkBV66m24kOdz7VaGW27o4RLOnyoiTXpIe7sQM3XkXa3f2ZWjZ05TgmCBF RtlEhE0F+rPC5wYEPmnSpEFSmWMvqzgVRJt8KYzfHjE7tC5T2HwDDNT2q+h6QAHCV6olB3IRr UbHfoT4YUZcjHYxOCW/soVe+PUBhTRxViZD/70FDteoH+sO1J00tusQSdLiX+U+UD/kZfi8/t ViIL7rS24MCneAcKX7M/KORmacrHdJMQKYqviEN0aNRcyEv74RLuBWngs9pbAozJaOF4NoGNz fM2nyaXYkzc1vdYkrFfqC5aXqAjqMwJqgWZa+Q4zJRGghPTZpOelA3HLImX8611eWbBgcKaLU gL4xFHjMrhdWJK97jCPucgjDTuo= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 14 Nov 2022 22:03:02 +0100 Laurenz Albe wrote: Oops, I forgot to say that a jsonb entry will automatically feed it's tsvector counterpart. Jean-Yves