On 1/10/21 2:44 AM, Tomas Vondra wrote: > 5) WHEN AND > > I admit the "WHEN AND" conditions sounds a bit cryptic - it took me a > while to realize what this refers to. Is that a term established by SQL > Standard, or something we invented?
The grammar gets it right but the error messages are nonsensical to me. I would like to see all user-facing instances of "WHEN AND" be replaced by the admittedly more verbose "WHEN [NOT] MATCHED AND". -- Vik Fearing