[Info-ingres] More on MERGE

Roy Hann specially at processed.almost.meat
Wed Nov 1 16:25:51 UTC 2023


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



More information about the Info-ingres mailing list