> How do you handle statements that rely on current_timestamp, random(),
> etc? What about if their reliance is via a function? Is that just an
> understood limitation of the cache, that it'll cache even queries that
> don't really make sense to cache?
Probably we should cache the result of a query which containts no
functions or a query which only contains immutable functions.
Also we should be carefull about views, which may be a result of non
immutable functions.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp