On Mon, Nov 16, 2015 at 4:06 AM, Geoff Winkless <pgsqlad...@geoff.dj> wrote:
> On 16 November 2015 at 10:55, Albe Laurenz <laurenz.a...@wien.gv.at> > wrote: > >> 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.