function digest(unknown, unknown) does not exist

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

function digest(unknown, unknown) does not exist

dbatoCloud Solution
Hi All,
While executing this below function I'm facing this error. 
Let me know if someone had the same issue in postgresql 10.x

ERROR:  function digest(unknown, unknown) does not exist
LINE 1: select encode(digest('123', 'sha256'),'hex');
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 15

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: function digest(unknown, unknown) does not exist

Ian Lawrence Barwick
2021年2月10日(水) 19:26 dbatoCloud Solution <[hidden email]>:
Hi All,
While executing this below function I'm facing this error. 
Let me know if someone had the same issue in postgresql 10.x

ERROR:  function digest(unknown, unknown) does not exist
LINE 1: select encode(digest('123', 'sha256'),'hex');
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 15

You probably need to install the pgcrypto extension, which contains this function [1]


 
Regards

Ian Barwick