howto use pgencrypto ? - Mailing list pgsql-novice

Hi,

I have installed pgencrypot so I think...
I ran make checkinstall I got:

============== installing PL/pgSQL
==============
============== running regression test queries
==============
test init                 ... ok
test md5                  ... ok
test sha1                 ... ok
test hmac-md5             ... ok
test hmac-sha1            ... ok
test blowfish             ... ok
test rijndael             ... ok
test crypt-des            ... ok
test crypt-md5            ... ok
test crypt-blowfish       ... ok
test crypt-xdes           ... ok

======================
 All 11 tests passed.
======================

But when I ran:

select encrypt
('srcip'::bytea,'pass'::bytea,'bf'::text)::bytea as
"test" from tbltcplog limit 3;

I got:

ERROR:  Function encrypt(bytea, bytea, text) does not
exist
        Unable to identify a function that satisfies
the given argument types
        You may need to add explicit typecasts

Please help!!!!
Thanks,
Dave

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/