[pgpool-general: 9480] Re: Question about usage of cache

[Achilleas Mantzios]

Good day Tatsuo!

On 9/5/25 06:41, Tatsuo Ishii wrote:

>> There are two types of date_bin which have different return types:
>> timestamp with time zone and timestamp without time zone, depending on
>> the input data types. Unfortunately pgpool is not clever enough to
>> distinguish them and thinks that your date_bin call is for the one
>> returning timestamp with time zone, and refuses to create query cache.
>> Workaround is, create a wrapper function for date_bin which returns
>> timestamp without time zone and use it in your query.
> Of course you can use /*FORCE QUERY CACHE*/ comment as well.
Makes sense.Thank you!
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS K.K.
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp