Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE OR REPLACE FUNCTION hash_text(input text) RETURNS text
LANGUAGE plpgsql
AS
$$
DECLARE
  res text;
BEGIN
  SELECT encode(sha256(input::bytea),  'escape') INTO res;
  RETURN res;
END
$$

-- Executing the function above

CREATE FUNCTION

SELECT hash_text('abc');

hash_text

\272x\277\217\317\352AA@\336]\256"#\260a\243\226z\234\264\377a\362\000\255

SELECT 1

SELECT encode(sha256('abc'),  'escape')

encode

\272x\277\217\317\352AA@\336]\256"#\260a\243\226z\234\264\377a\362\000\255

SELECT 1