Actually, what is bytea in terms of type, or rather, what types of database
fields will this work with? The field I'm calling from the table is varchar
(the encrypt function worked find for this).
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, January 27, 2011 6:15 PM
To: David Patricola
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Pgcrypto install (I've tried multiple ways)
"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