Skip to content
  • Dean Rasheed's avatar
    Add support for MERGE ... WHEN NOT MATCHED BY SOURCE. · 0294df2f
    Dean Rasheed authored
    This allows MERGE commands to include WHEN NOT MATCHED BY SOURCE
    actions, which operate on rows that exist in the target relation, but
    not in the data source. These actions can execute UPDATE, DELETE, or
    DO NOTHING sub-commands.
    
    This is in contrast to already-supported WHEN NOT MATCHED actions,
    which operate on rows that exist in the data source, but not in the
    target relation. To make this distinction clearer, such actions may
    now be written as WHEN NOT MATCHED BY TARGET.
    
    Writing WHEN NOT MATCHED without specifying BY SOURCE or BY TARGET is
    equivalent to writing WHEN NOT MATCHED BY TARGET.
    
    Dean Rasheed, reviewed by Alvaro Herrera, Ted Yu and Vik Fearing.
    
    Discussion: https://postgr.es/m/CAEZATCWqnKGc57Y_JanUBHQXNKcXd7r=0R4NEZUVwP+syRkWbA@mail.gmail.com
    0294df2f