Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure - Mailing list pgsql-general

From Michael Fuhr
Subject Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure
Date
Msg-id 20050709120606.GB36147@winnie.fuhr.org
Whole thread Raw
In response to PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure  ("Enrico Riedel" <enricoriedel@thunderelectricinc.com>)
List pgsql-general
On Fri, Jul 08, 2005 at 04:43:41PM -0500, Enrico Riedel wrote:
>
> I tried to find a function that calculates the SHA (preference is sha-256),
> but could not find anything for PostGRE. However, I want to implement the
> calculation within the DB, for several reasons.

See the contrib/pgcrypto module.

BTW, it's PostgreSQL or Postgres, not PostGRE.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Geert Jansen
Date:
Subject: Transaction isolation levels
Next
From: Michael Fuhr
Date:
Subject: Re: Transaction isolation levels