Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Implement INSERT SET syntax - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: [PATCH] Implement INSERT SET syntax
Date
Msg-id CAL9smLAw-D5n=XF=K9a-5x79eSXhNoMO1Cv-gtvUD-OMiLha_g@mail.gmail.com
Whole thread Raw
In response to [PATCH] Implement INSERT SET syntax  (Gareth Palmer <gareth@internetnz.net.nz>)
Responses Re: [PATCH] Implement INSERT SET syntax  (Gareth Palmer <gareth@internetnz.net.nz>)
List pgsql-hackers
Tree view
On Wed, Jul 17, 2019 at 7:30 AM Gareth Palmer <gareth@internetnz.net.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

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg_receivewal documentation
Next
From: 张连壮
Date:
Subject: Re: pg_stat_database update stats_reset only by pg_stat_reset