On 16 November 2015 at 10:55, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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