1. Forum
  2. USENET
  3. comp.databases.ingres

  • More on MERGE

    From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Fri Oct 27 14:50:23 2023
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Wed Nov 1 16:25:51 2023
    From Newsgroup: comp.databases.ingres

    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

    --- Synchronet 3.21b-Linux NewsLink 1.2