From: | dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | function digest(unknown, unknown) does not exist |
Date: | 2021-02-10 10:26:36 |
Message-ID: | CAEz7P_svR0tk-FCdtwK=S_Oh8H+GnB4zxx2X+wcxFG-AuHsbMw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Lawrence Barwick | 2021-02-10 11:04:45 | Re: function digest(unknown, unknown) does not exist |
Previous Message | Fernando Hevia | 2021-02-09 20:12:16 | Re: Postgres 12 -> 13 any need to re-index? |