Aaron Burnett <aburnett(at)bzzagent(dot)com> writes:
> 9.1.3 is just not decrypting nor throwing errors.
> 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
> decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
> 'aes-cbc');
> decrypt_iv
> --------------------------
> \x48656c6c6f205468657265
> (1 row)
I think this is the same result, it's just being shown in hex.
See the bytea_output configuration parameter.
regards, tom lane