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

Поиск
Список
Период
Сортировка
От Enrico Riedel
Тема PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure
Дата
Msg-id 20050708214342.08E1E529C8@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure  (Michael Fuhr <mike@fuhr.org>)
Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea  (Stuart Bishop <stuart@stuartbishop.net>)
Список pgsql-general
Hi!

I have the following scenario:
    Table:
        Fil_no    BigSerial
        Fil_Name    varchar
        Fil_Data    Bytea
        Fil_HASH    varchar

    Trigger:
        Before Insert  (in Pseudo Code)
            ...
            vchSHA = SHA(Fil_DATA)
            NEW.Fil_HASH = vchSHA
            ...

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.

Has anyone an idea on how or any pointer into the right direction to
accomplish the above task?

Thanks already in advance!

-Enrico




В списке pgsql-general по дате отправления:

Предыдущее
От: "Adam Pritchard"
Дата:
Сообщение: index usage in multi-column ORDER BY
Следующее
От: "Adam Pritchard"
Дата:
Сообщение: many updates to single row in single transaction