sql - Function does not exist in PostgreSQL

Question

I have this Postgres code

CREATE PROCEDURE adjust_available(patientBed UUID)
LANGUAGE SQL
AS $$
    UPDATE bed
    SET available = false
    WHERE bed.id = patientBed;
$$;

CREATE TRIGGER adjust_available
    AFTER UPDATE OF bed ON patient
    FOR EACH ROW
    EXECUTE PROCEDURE adjust_available(bed);

However when you run this query. It says the function does not exist. However, you create it above?

The full error:

ERROR: function adjust_available() does not exist SQL state: 42883

question from:https://stackoverflow.com/questions/65835472/function-does-not-exist-in-postgresql

Answer 1

Waitting for answers