Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: referencing other INSERT VALUES columns inside the insert
Date
Msg-id CAKFQuwaRYYUXyrv5qz7_YOiDMqEmDy-K1nTvosfq_nHh9XMp2A@mail.gmail.com
Whole thread Raw
In response to Re: referencing other INSERT VALUES columns inside the insert  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: referencing other INSERT VALUES columns inside the insert
List pgsql-general
Tree view
On Mon, Nov 16, 2015 at 4:06 AM, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
On 16 November 2015 at 10:55, Albe Laurenz <laurenz.albe@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.
​
 

pgsql-general by date:

Previous
From: Cj B
Date:
Subject: bdr appears to be trying to replicate to itself
Next
From: Alvaro Herrera
Date:
Subject: Re: bdr appears to be trying to replicate to itself