Re: MERGE Specification

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: Petr Jelinek <pjmodos@pjmodos.net>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2008-04-25T13:10:57Z

Lists: pgsql-hackers

Simon Riggs wrote:

> 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.

... and raise an ERROR when there is no unique index?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support