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! Geoff
