Postgres Pro
Downloads
Home   >   mailing lists

How do you control IMMUTABLE PG PROC results? - Mailing list pgsql-general

From Carlo Stonebanks
Subject How do you control IMMUTABLE PG PROC results?
Date
Msg-id iaviq7$27dh$1@news.hub.org
Whole thread Raw
Responses Re: How do you control IMMUTABLE PG PROC results?
Re: How do you control IMMUTABLE PG PROC results?
List pgsql-general
Tree view 
We have procs that would benefit from returning IMMUTABLE results. The procs
are dependent on external tables that rarely change, but when they DO
change, it would be great if we could expire the cache that the procs read
from so that the procs are forced to re-evaluate the results.

Is this possible?

How do I know how many possible results are cached?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select to_char(current_timestamp, 'YYYY-WW');
Next
From: Alexander Farber
Date:
Subject: Re: select to_char(current_timestamp, 'YYYY-WW');