Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.
Date
Msg-id 21796.986013331@sss.pgh.pa.us
Whole thread Raw
In response to BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.  (Jacek Konieczny <jajcus@bnet.pl>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: LATIN2 and wrong upper() and lower() functions output
Next
From: Peter Eisentraut
Date:
Subject: Re: unix_socket_directory isn't used by all bin tools