how much volatile is a function

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: how much volatile is a function
Date: 2012-07-12 18:38:30
Message-ID: 001501cd605d$999e0ef0$ccda2cd0$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-07-12 18:48:54 Re: how much volatile is a function
Previous Message Bartosz Dmytrak 2012-07-12 18:14:40 Re: PostgreSQL limitations question