COPY (INSERT/UPDATE/DELETE .. RETURNING ..) - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject COPY (INSERT/UPDATE/DELETE .. RETURNING ..)
Date
Msg-id 5634FF29.7000000@joh.to
Whole thread Raw
Responses Re: COPY (INSERT/UPDATE/DELETE .. RETURNING ..)
Re: COPY (INSERT/UPDATE/DELETE .. RETURNING ..)
List pgsql-hackers
Hi,

Attached is a patch for being able to do $SUBJECT without a CTE.  The
reasons this is better than a CTE version are:

   1) It's not obvious why a CTE version works but a plain one doesn't
   2) This one has less overhead (I measured a ~12% improvement on a
not-too-unreasonable test case)

With regard to RULEs, similar restrictions apply as the ones on
data-modifying statements in WITH.

I can't add this to November's commit fest, but I'm posting this anyway
in case someone is thinking about implementing this feature.


.m

Attachment

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: pg_stat_statements query jumbling question
Next
From: Julien Rouhaud
Date:
Subject: Re: [BUGS] BUG #12989: pg_size_pretty with negative values