Re: SET syntax in INSERT - Mailing list pgsql-hackers

From Marc Mamin
Subject Re: SET syntax in INSERT
Date
Msg-id B6F6FD62F2624C4C9916AC0175D56D88420D893A@jenmbs01.ad.intershop.net
Whole thread Raw
In response to Re: SET syntax in INSERT  (Marko Tiikkaja <marko@joh.to>)
List 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


pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: SET syntax in INSERT
Next
From: Pavel Stehule
Date:
Subject: Re: SET syntax in INSERT