- STABLE : If you call it with the same arguments more than once during the execution of a single query it will return the same value
- IMMUTABLE : It will always return the same value for the same arguments, regardless of database contents or the passage of time