Re: MERGE Specification

On Fri, 2008-04-25 at 11:07 +0200, Petr Jelinek wrote:

> Another thing is, the table on which we do SELECT (the one in USING) can 
> be different from target table and we can use columns from that table in 
> INSERT/UPDATE statement (probably one the reasons why spec says the 
> "SELECT" query has to be executed before any changes). How you want to 
> use the "INSERT first" implementation in this scenario ? IMHO you still 
> need to have both implementations in the end. So we probably need to 
> implement the standard one first and then implement our version and put 
> some restrictions of what can be in USING or INSERT part when using it.

We do this:

1. Run using clause,

then for each row

2. NOT MATCHED rules
3. MATCHED

I'm now happy that we can get a spec-compliant end result by always
forcing NOT MATCHED rules to occur before MATCHED rules, when we have at
least one unique index.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com