Using digest in a stored procedure

[Tarang]

Hi,

I am trying to use digest in a stored procedure

create or replace FUNCTION hello_world(
	)
	RETURNS text
	language plpgsql    
	as $$
	DECLARE

	BEGIN
		
			
		RETURN encode(digest(('HEY'::text)::bytea, 'sha1'), 'hex');
		
	END;
	$$

Then I try to call it using the supabase rpc method and i get this error

{"hint":"No function matches the given name and argument types. You might need to add explicit type casts.","details":null,"code":"42883","message":"function digest(bytea, unknown) does not exist"}

However, if I run it in SQL it works fine

I'm not too sure whats going wrong here

[steve-chavez]

Try using it digest like:

select  encode(extensions.digest(('HEY'::text)::bytea, 'sha1'), 'hex');;

For more info, check: #1048 (comment)