On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Thank you so much for your information. I installed the pgCrypto. Now I have more than 40 functions (i believe all are from pgcrypto) but when I try to run your query: select encode(digest('blahblah', 'sha256'), 'hex'); I got the error: ERROR: Cannot use "sha256": No such hash algorithm SQL state: 22023
It may not be available in your version of the database/pgcrypto module, my test was performed on 8.2.3.