Re: Can we get sha* function over text, that could be used in index? - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Can we get sha* function over text, that could be used in index?
Date
Msg-id owheexmogjkdf2uh4johukkwsi66wkixxfgnxqa77baftwsr25@sfcuuz3ikojv
Whole thread
In response to Re: Can we get sha* function over text, that could be used in index?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
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


--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: Pawel Kudzia
Date:
Subject: Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?
Next
From: dolan@directdemocracysolutions.com
Date:
Subject: Recovery Verification