Re: pgcryto strangeness...

Sean Chittenden <sean@chittenden.org> writes:
> Yeah, it does... but it also tells me I'm SOL for 7.1.3 even though
> pgcrypto comes with a DECODE() function (only supports 'hex' and
> 'base64').  Any other ideas?  <:~)  -sc

So, create yourself another function.  In pgcrypto.sql.in I see

CREATE FUNCTION digest(bytea, text) RETURNS bytea AS 'MODULE_PATHNAME', 'pg_digest' LANGUAGE 'C';

You could add

CREATE FUNCTION digest(text, text) RETURNS bytea AS 'MODULE_PATHNAME', 'pg_digest' LANGUAGE 'C';

which should work fine since the internal representation of text isn't
really different from that of bytea.
        regards, tom lane