Horton

Re: Intersection or zero-column queries

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Victor Yegorov <vyegorov@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-12-22T02:59:46Z
Lists: pgsql-general 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, December 21, 2017, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So yeah, it's wrong ... but personally I'm not terribly excited
>> about fixing it.  Maybe somebody else wants to; but what's the
>> practical use?

> How about just erroring out?

Hm, yeah, inserting a FEATURE_NOT_SUPPORTED error might be an
appropriate amount of effort.

			regards, tom lane

Commits

  1. Disallow UNION/INTERSECT/EXCEPT over no columns.

  2. Fix UNION/INTERSECT/EXCEPT over no columns.