Tuesday, May 9, 2017

PostgreSQL: immutable vs stable

Reminder:

  • 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