Message-ID:

I have a theory that it's impossible to prove anything, but I can't prove it.

devel / comp.databases.ingres / More on MERGE

More on MERGE

<uhginf$2anpq$1@dont-email.me>

https://www.rocksolidbbs.com/devel/article-flat.php?id=293&group=comp.databases.ingres#293

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: More on MERGE
Date: Fri, 27 Oct 2023 14:50:23 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 6
Message-ID: <uhginf$2anpq$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 27 Oct 2023 14:50:23 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="6dc1a9d0be5af040d0881c7b5c74cb58";
logging-data="2449210"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19usmZLLm2Rx1idbn4a1000SMKiTN7A25g="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:0IF4QK1/cCM0rr3/DHAJudDwa5c=

by: Roy Hann - Fri, 27 Oct 2023 14:50 UTC

This is super annoying. After finally working out the full syntax of the
MERGE statement I discover it is not supported in database procedures!

Boo to that.

Roy

Re: More on MERGE

<uhtu6f$1mj8b$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=294&group=comp.databases.ingres#294

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: More on MERGE
Date: Wed, 1 Nov 2023 16:25:51 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 15
Message-ID: <uhtu6f$1mj8b$1@dont-email.me>
References: <uhginf$2anpq$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 1 Nov 2023 16:25:51 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="74c909b46b0b2dd3fc607c8b15e3a765";
logging-data="1789195"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+DEc7Jv7ljWyHDX2ihNibCtCwLcYCEP7o="
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
Cancel-Lock: sha1:7UnK5YQdgDU2sfyE0vndHGTHUn4=

by: Roy Hann - Wed, 1 Nov 2023 16:25 UTC

Roy Hann wrote:

> This is super annoying. After finally working out the full syntax of the
> MERGE statement I discover it is not supported in database procedures!

Now I'm just looking for reasons to carp.

It turns out we can't use a common table expression for the table-ref
(per the EBNF).

Both limitations are reflected in the documentation but neither is
called out.

Roy

Subject	Author
More on MERGE	Roy Hann
Re: More on MERGE	Roy Hann