David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> writes:> 2) Does the optimizer cache the result of identical subqueries (e.g. :x1 > or :x2, which is mentioned several times in the query)?
No.
regards, tom lane