Re: merge with view

2024-03-11 Thread Adrian Klaver
On 3/11/24 13:25, Lorusso Domenico wrote: Hello guys, Merge isn't work on view; anyone know why? I mean, merge could be performed in many way, but essentially is: * join sets * if matched update or delete * if not matched insert it doesn't seem to be relevant if set is a table or a view.

merge with view

2024-03-11 Thread Lorusso Domenico
Hello guys, Merge isn't work on view; anyone know why? I mean, merge could be performed in many way, but essentially is: - join sets - if matched update or delete - if not matched insert it doesn't seem to be relevant if set is a table or a view. Moreover also "insert + on conflict" doe