In PostgreSQL's PL$/$pgSQL functions: the deterministic attribute tells the query optimizer that the function cannot modify the database and always returns the same result when given the same argument values.