Horton

Re: Intersection or zero-column queries

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Victor Yegorov <vyegorov@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-12-22T02:42:36Z
Lists: pgsql-general 
On Thursday, December 21, 2017, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> which would only be the right plan for UNION ALL.
>
> 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?

David J.

Commits

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

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