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

[Tatsuo Ishii]

> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp