PostgreSQL functions and stored procedures can now be created using the SQL-standard BEGIN ATOMIC definition. Using BEGIN ATOMIC allows function bodies to be parsed on creation and also provides dependency. For example:
CREATE FUNCTION add(int, int)
RETURNS int
IMMUTABLE PARALLEL SAFE
BEGIN ATOMIC;
SELECT $1 + $2;
END;