What about something along these lines:
INSERT INTO test (c1, c2, c3)
(WITH fixed(x1, x2) AS (VALUES (3, 7))
SELECT x1, x2, x1 * x2 FROM fixed);
Genius!It never occured to me that the with_query parameter could be used that way. Thanks!
You don't need WITH to accomplish this...
INSERT INTO test (c1, c2, c3)
SELECT c1, c2, c1 * c2
FROM ( VALUES (3, 7) ) vals (c1, c2);
David J.
