Re: [PATCH] Implement INSERT SET syntax

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Implement INSERT SET syntax
Date: 2019-08-18 14:35:22
Message-ID: 31768.1566138922@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> writes:
> On 18/08/2019 11:03, Peter Eisentraut wrote:
>> a UNION b
>> vs
>> a UNION CORRESPONDING b

> I have a WIP patch for CORRESPONDING [BY].  Is there any interest in me
> continuing it?  If so, I'll start another thread for it.

CORRESPONDING is in the SQL standard, so in theory we ought to provide
it. I think the hard question is how big/complicated the patch would be
--- if the answer is "complicated", maybe it's not worth it. People
have submitted patches for it before that didn't go anywhere, suggesting
that the tradeoffs are not very good ... but maybe you'll think of a
better way.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nino Floris 2019-08-18 14:56:27 [PATCH] ltree, lquery, and ltxtquery binary protocol support
Previous Message Vik Fearing 2019-08-18 12:28:16 Re: [PATCH] Implement INSERT SET syntax