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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jacek Konieczny <jajcus(at)bnet(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG: Each UNION | EXCEPT | INTERSECT query must have the same number of columns.
Date: 2001-03-31 04:35:31
Message-ID: 21796.986013331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jacek Konieczny <jajcus(at)bnet(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-03-31 08:38:29 Re: unix_socket_directory isn't used by all bin tools
Previous Message Bruce Momjian 2001-03-31 01:14:50 Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP