From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Anibal David Acosta Sent: Thursday, July 12, 2012 2:39 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: how much volatile is a function I have a table, this table are rarely changed (added or deleted). My function receive parameters and do a query to the table. Does postgres re run the query on each function call, or has some kind of "flag" indicating that table as not been changed and return cached result of a previous call if the call has same parameters? Thanks! ============================================== See here: http://www.postgresql.org/docs/9.1/interactive/sql-createfunction.html Read the difference between IMMUTABLE, STABLE, and VOLATILE David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
