Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Shepelev <MichaelS(at)alias(dot)ru>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: PostgreSQL 7.0 beta 4: Error in Insert/Select
Date: 2000-04-25 06:10:02
Message-ID: 12014.956643002@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Michael Shepelev <MichaelS(at)alias(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Servio MedinaDate: 2000-04-25 20:04:55
Subject:
Previous:From: Michael ShepelevDate: 2000-04-25 04:41:02
Subject: PostgreSQL 7.0 beta 4: Error in Insert/Select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group