Path: csiph.com!news.mixmin.net!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Roy Hann <specially@processed.almost.meat>
Newsgroups: comp.databases.ingres
Subject: Re: MERGE syntax
Date: Thu, 26 Oct 2023 16:37:45 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 15
Message-ID: <uhe4kp$1netn$1@dont-email.me>
References: <uhdoq5$1k0nd$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 26 Oct 2023 16:37:45 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="ad08077fed4979a3d5d19c34b434a8bf"; logging-data="1817527"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18mEPgEE/dibzEBqehPjAhORdthYR/llLk="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:PjALJ/G2isXRSeeKZtWglL8md2I=
Xref: csiph.com comp.databases.ingres:3903

Roy Hann wrote:

> I am just trying to understand the syntax. I can't think of a reason to 
> ever do multiple updates with the same matching condition.

Unless someone tells me different, I'm starting to think this is just
another example where EBNF runs out of steam.

I think that description is just trying to tell us it doesn't matter
in what order we specify the DELETE action and the UPDATE action.
Semantically, we're allowed only one of each.

Am I right?

Roy