Re: [BUGS] PostgreSQL 7.0 beta 4: Error in Insert/Select

[Tom Lane]

Michael Shepelev <[EMAIL PROTECTED]> 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