Horton

Re: PostgreSQL 7.0 beta 4: Error in Insert/Select

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

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Shepelev <MichaelS@alias.ru>
Cc: "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>
Date: 2000-04-25T06:10:02Z
Lists: pgsql-bugs 
Michael Shepelev <MichaelS@alias.ru> writes:
> I found bug (IMHO) in Insert/Select Union command.
> Result of SELECT UNION differs from INSERT SELECT UNION.

Wow, that's bizarre.  I confirm seeing the inconsistent behavior.

I think it's probably got something to do with the UNION code's
manipulations of the query targetlist, but am too tired to puzzle out
more tonight.  Anyone else want to look at it?

			regards, tom lane