> 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.
Tom, you're a regular postgres god. ;~) That works beautifully! I'm
cooking along now, thanks 'all!
Real quick, is anyone else is interested, I'm turning pgcrypto into a
port for FreeBSD. I'm mostly done, so if anyone has any interest in
testing this (very strange port to make because you have to copy the
backend headers out of the postgres tarball and into the include path.
I know this is changing with 7.2, but it's not out yet. ::grin::),
please let me know. -sc
--
Sean Chittenden