Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 7.0 beta 4: Error in Insert/Select - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Date
Msg-id 12014.956643002@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 7.0 beta 4: Error in Insert/Select  (Michael Shepelev <MichaelS@alias.ru>)
Responses Re: PostgreSQL 7.0 beta 4: Error in Insert/Select  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Michael Shepelev
Date:
Subject: PostgreSQL 7.0 beta 4: Error in Insert/Select
Next
From: Servio Medina
Date:
Subject: