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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Enrico Riedel <enricoriedel(at)thunderelectricinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure
Date: 2005-07-09 12:06:06
Message-ID: 20050709120606.GB36147@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-07-09 13:02:40 Re: Transaction isolation levels
Previous Message Dennis Bjorklund 2005-07-09 11:18:11 Re: many updates to single row in single transaction