David Garamond <[EMAIL PROTECTED]> 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
---(end of broadcast)---
On my first try, interpolation and extrapolation turns out to be pretty
easy to do. In psql:
-- the "lookup" table
CREATE TABLE p (
x DOUBLE PRECISION NOT NULL UNIQUE,
y DOUBLE PRECISION NOT NULL
);
INSERT INTO p VALUES (1,1);
INSERT INTO p VALUES (2,5);
INSERT INTO p VALUES (5,14);
INSERT I