Playing with pgcrypto - Mailing list pgsql-general

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_sym_encrypt('123', 'secret') = p1;

Thanks.

Howard