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 <kamaual...@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
