Re: referencing other INSERT VALUES columns inside the insert - Mailing list pgsql-general

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);