On Mon, Nov 16, 2015 at 4:06 AM, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:
> 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!
>
>
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.