Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vtmIE-00CFXZ-1E for pgsql-general@arkaria.postgresql.org; Sat, 21 Feb 2026 12:41:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vtmIB-009nrg-0N for pgsql-general@arkaria.postgresql.org; Sat, 21 Feb 2026 12:41:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vtmIA-009nrX-2W for pgsql-general@lists.postgresql.org; Sat, 21 Feb 2026 12:41:02 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vtmI5-00000000Vpt-0WqQ for pgsql-general@lists.postgresql.org; Sat, 21 Feb 2026 12:41:01 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id 35A0C662B6; Sat, 21 Feb 2026 13:40:55 +0100 (CET) Date: Sat, 21 Feb 2026 13:40:55 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: Can we get sha* function over text, that could be used in index? Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org References: <3dbae091-6168-4b4b-91dc-4bf1a3a51136@eisentraut.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4uhc4toduids6qfy" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4uhc4toduids6qfy Content-Type: text/plain; protected-headers=v1; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Subject: Re: Can we get sha* function over text, that could be used in index? MIME-Version: 1.0 On 2026-02-19 23:30:17 +0100, Peter J. Holzer wrote: > Something like > encode(s text, enc text) -> bytea > decode(d bytea, enc text) -> text > might be generally useful. Please ignore this email. These are basically the same as convert_to() and convert_from() which already exist. hjp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --4uhc4toduids6qfy Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmmZp9AACgkQ8g5IURL+ KF0Rww/+I8usoLHi9n7jXkZPPnEJRqg7sOoHs8TlnOfMVED/BmHHXpTGO9O6d6tB ENSj9BDokGVvGAjRSZpSLOMb893f0K8tBBO40j8mHAczoYI9F7+hNAlpeaAg9wJZ tTFD424zk2/CuqSNbzIbGG+8oLenfiQKMajyuqCLDIZrFdwwuSaujwkj4hq860o4 nuDEmvs9hg2ptDjobj1N8Y78QWG5p8SDxVwaFbC130GAwH07maLBpznG0GeF11h2 xZmN1UGzoGsEv7iHsDX61pCkgu7Bq1dsMZxzmWrsPTslrbN7Wprj1jgihJWBDEtr ckVYLOVnuq77weDU5Ki9sz3JxUVWMvFKz9M/+s+9dXjt+5jINzWJyhL1Ci4KmTfZ e0An8fgpanIPMCkqbeQjgCCkwaEsDPNCMC6IuX1uXgcrqHIJ4vxeAvVBjy579ovy f+iUDYn0vfiIbPKic+aMvClS11pq13V5HDihb5V1iI1VQF3hi8nZiompKO1LCZQL EFs00BWFzISkQeLuWnxJJwgEwy6djfx5jjUpQpcjpnK0qX1stIon1KpKF7KdFmCP Xm4rugnnnH+Cv3ipEUKjZPV9+obQp1xxjGJNR80yyO1HPneR67y0J2fysgBTxOIO i4qwSCPM8BgMlCfYdhqhxZHOvMx3MIEQ3BcVi/3FaAKhWwDLtJM= =z8Wi -----END PGP SIGNATURE----- --4uhc4toduids6qfy--