Hi, since there is a md5 function in PG, does anybody know if there is a
plan to add the support for SHA family digest functions in PG>9?

Anselmo Canfora <nobody (AT) nowhere (DOT) net> wrote:
You can use that already, see
http://www.postgresql.org/docs/curre.../pgcrypto.html


Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Il 29/06/2010 7.30, Andreas Kretschmer ha scritto:
It works perfectly, thanks!

db_atm=# \i /usr/share/postgresql/8.3/contrib/pgcrypto.sql
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

db_atm=# select encode(digest('test', 'sha256'), 'hex');
encode
------------------------------------------------------------------
9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd1 5d6c15b0f00a08
(1 row)