Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)?

Well I don't think the result would keep if you run a "hot" test. However,
in one SELECT clause, maybe it can be optimised .

2009/9/3 Allan Kamau <kamauallan(at)gmail(dot)com>

> Hi,
> I do have a query which make use of the results of an aggregate
> function (for example bit_or) several times in the output column list
> of the SELECT clause, does PostgreSQL simply execute the aggregate
> function only once and provide the output to the other calls to the
> same aggregate function.
> How about the case of non volatile functions? Do they get executed as
> many times as they occur in the select clause?
>
> Allan.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>