"David Patricola" <david.patricola@jefferson.edu> writes:
> I ran the script under database 'testdb', and that's the database I'm
> viewing when in pgAdmin. Here's what \df decript gave me:
> Schema | Name | Result data type | Argument data types | Type
> -------+---------+------------------+---------------------+--------
> public | decrypt | bytea | bytea, bytea, text | normal
> (it finds all of the functions, in fact)
> However, when I run this query it says it can't find the function with the
> given name and datatypes.
> select decrypt(thenotes, 'thekey', 'aes') AS theoutput
> from footable
So is "thenotes" of type bytea?
regards, tom lane