Re: BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jacek Konieczny <jajcus@bnet.pl>
Cc: pgsql-bugs@postgresql.org
Date: 2001-03-31T04:35:31Z
Lists: pgsql-bugs
Jacek Konieczny <jajcus@bnet.pl> writes:
> CREATE TABLE tb1 ( a CHARACTER(10) DEFAULT 'abc', b CHARACTER(10));
> CREATE TABLE tb2 ( a CHARACTER(10), b CHARACTER(10));
> INSERT INTO tb1(b) SELECT b FROM tb2 EXCEPT SELECT b FROM tb1;

This is fixed for 7.1.

			regards, tom lane