• More on MERGE

    From Roy Hann@21:1/5 to All on Fri Oct 27 14:50:23 2023
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Roy Hann on Wed Nov 1 16:25:51 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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)