Re: Can we get sha* function over text, that could be used in index?

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Can we get sha* function over text, that could be used in index?
Date: 2026-02-21 12:40:55
Message-ID: owheexmogjkdf2uh4johukkwsi66wkixxfgnxqa77baftwsr25@sfcuuz3ikojv
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dolan 2026-02-23 22:07:47 Recovery Verification
Previous Message Pawel Kudzia 2026-02-21 10:20:07 Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?