From b64496a1907e7e3a2ffd7435ab231365f1143a2e Mon Sep 17 00:00:00 2001
From: Tatsuo Ishii <ishii@sraoss.co.jp>
Date: Tue, 19 Jul 2022 22:14:41 +0900
Subject: [PATCH] Doc: mention that certain SELECTs are not cached.

SELECTs including TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE
SELECTs including CAST to TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE
SELECTs including SQLValueFunction (CURRENT_TIME, CURRENT_USER etc.)
---
 doc.ja/src/sgml/memcache.sgml | 3 +++
 doc/src/sgml/memcache.sgml    | 3 +++
 2 files changed, 6 insertions(+)

diff --git a/doc.ja/src/sgml/memcache.sgml b/doc.ja/src/sgml/memcache.sgml
index 647856493..bd5284891 100644
--- a/doc.ja/src/sgml/memcache.sgml
+++ b/doc.ja/src/sgml/memcache.sgml
@@ -39,6 +39,9 @@
    基本的に以下のSELECTはキャッシュされません。
    <programlisting>
     immutableでない関数を含むSELECT
+    TIMESTAMP WITH TIMEZONE、TIME WITH TIMEZONEを返す関数を使っているSELECT
+    TIMESTAMP WITH TIMEZONE、TIME WITH TIMEZONEへのキャストを含むSELECT
+    SQLValueFunction (CURRENT_TIME, CURRENT_USERなど)を含むSELECT
     一時テーブル、unloggedテーブルを使ったSELECT
     検索結果が memqcache_maxcache を越えるようなSELECT
     SELECT FOR SHARE/UPDATE
diff --git a/doc/src/sgml/memcache.sgml b/doc/src/sgml/memcache.sgml
index 710f8e055..2e350c59a 100644
--- a/doc/src/sgml/memcache.sgml
+++ b/doc/src/sgml/memcache.sgml
@@ -26,6 +26,9 @@
    <programlisting>
     SELECTs including non immutable functions
     SELECTs including temp tables, unlogged tables
+    SELECTs including TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE
+    SELECTs including CAST to TIMESTAMP WITH TIMEZONE or TIME WITH TIMEZONE
+    SELECTs including SQLValueFunction (CURRENT_TIME, CURRENT_USER etc.)
     SELECT result is too large (memqcache_maxcache)
     SELECT FOR SHARE/UPDATE
     SELECT starting with "/*NO QUERY CACHE*/" comment
-- 
2.39.5