Re: pgcrypto - Mailing list pgsql-general

On Wed, Sep 23, 2015 at 8:46 AM, Ramesh T <rameshparnanditech@gmail.com> wrote:

Hi,

      i   created extension pgcrypto on public with postgres user.But while trying to use from my own schma suppose qa.

when i run digest in function  in my qa 

 CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$

      SELECT encode(digest($1, 'sha1'), 'hex')

    $$ LANGUAGE SQL STRICT IMMUTABLE;

 
 CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $
       SELECT encode(public.digest($1, 'sha1'), 'hex')
     $ LANGUAGE SQL STRICT IMMUTABLE;