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