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: [email protected]
Views: Whole Thread | Raw Message | 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