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

[Tom Lane]

Jacek Konieczny <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]