| From: | Marko Tiikkaja <marko(at)joh(dot)to> |
|---|---|
| To: | Gareth Palmer <gareth(at)internetnz(dot)net(dot)nz> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Implement INSERT SET syntax |
| Date: | 2019-07-17 05:52:06 |
| Message-ID: | CAL9smLAw-D5n=XF=K9a-5x79eSXhNoMO1Cv-gtvUD-OMiLha_g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jul 17, 2019 at 7:30 AM Gareth Palmer <gareth(at)internetnz(dot)net(dot)nz>
wrote:
> Attached is a patch that adds the option of using SET clause to specify
> the columns and values in an INSERT statement in the same manner as that
> of an UPDATE statement.
>
Cool! Thanks for working on this, I'd love to see the syntax in PG.
There was a brief discussion regarding INSERT SET on pgsql-hackers in late
> August 2009 [1].
>
There was also at least one slightly more recent adventure:
https://www.postgresql.org/message-id/709e06c0-59c9-ccec-d216-21e38cb5ed61%40joh.to
You might want to check that thread too, in case any of the criticism there
applies to this patch as well.
.m
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 张连壮 | 2019-07-17 05:52:46 | Re: pg_stat_database update stats_reset only by pg_stat_reset |
| Previous Message | Laurenz Albe | 2019-07-17 05:40:48 | Re: pg_receivewal documentation |