Re: Interpolation and extrapolation in SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Interpolation and extrapolation in SQL
Date: 2004-09-13 15:16:33
Message-ID: 10381.1095088593@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message andrew 2004-09-13 18:13:08 Re: CREATE RULE ignored, what did I do wrong
Previous Message David Garamond 2004-09-13 15:03:32 Interpolation and extrapolation in SQL