Re: SET syntax in INSERT

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: Marko Tiikkaja <marko(at)joh(dot)to>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SET syntax in INSERT
Date: 2016-01-14 19:14:54
Message-ID: B6F6FD62F2624C4C9916AC0175D56D88420D893A@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>SET syntax for INSERT was brought up a few years ago here:
>http://www.postgresql.org/message-id/2c5ef4e30908251010s46d9d566m1da21357891bab3d@mail.gmail.com

>What do we think?

+1
this would save comments in long queries.
and usindg AS as style helper as suggested in the old post has its caveat:

create temp table t( a int,b int);

insert into t select
1 as b,
2 as a;

select * from t ...

regards,
Marc Mamin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-01-14 19:15:52 Re: SET syntax in INSERT
Previous Message Marko Tiikkaja 2016-01-14 19:09:49 Re: SET syntax in INSERT