In Postgres, perform a partial match on an encrypted column value

-- Enable the pg_trgm extensionCREATE EXTENSION pg_trgm;-- Create a table with an encrypted columnCREATE TABLE encrypted_data (  id SERIAL PRIMARY KEY,  encrypted_column TEXT ENCRYPTED USING 'aes');-- Insert some encrypted dataINSERT INTO encrypted_data (encrypted_column)VALUES ('encrypted value 1'), ('encrypted value 2');-- Create a trigram index on the encrypted columnCREATE INDEX encrypted_data_encrypted_column_trigram_idxON encrypted_data USING gin (encrypted_column gin_trgm_ops);-- Perform a partial match on the encrypted columnSELECT *FROM encrypted_dataWHERE encrypted_column % 'encrypt';