pgp_sym_encrypt uses a random salt each time, so you cannot compare the
output
to p1 like you would do with crypt to verify a given plaintext.
Instead, use
pgp_sym_decrypt with p1 as input to get the plaintext.
--
Erik
Ah! That makes sense. Thanks Erik!
Hi Howard,
> On 11/10/2022 00:25 CEST howardn...@selestial.com wrote:
>
> I am trying out a few pgcrypto functions. I was expecting the final
> select statement to return the row I just inserted - Can anyone tell me
> what I am not understanding here?
>
> create table test (p1 bytea);
> insert
Hi all,
I am trying out a few pgcrypto functions. I was expecting the final
select statement to return the row I just inserted - Can anyone tell me
what I am not understanding here?
create table test (p1 bytea);
insert into test (pgp_sym_encrypt('123', 'secret'));
select * from test where pgp
