function digest(unknown, unknown) does not exist

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

Responses

Browse pgsql-admin by date

  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?