8.1 Update From Example

I think today might have been the first time I had to use update from on the fly on a production system. I’ve previously always used the “missing-from-clause” style syntax, like this: UPDATE sarbel_ejemplo SET clientele_call = ejemplo.clientele_call WHERE ejemplo_id = ejemplo.ejemplo_id AND ejemplo.valid AND NOT ejemplo.complete; Of course the new(ish) and fancy way to do such a thing would be: UPDATE sarbel_ejemplo SET clientele_call = e.clientele_call FROM ejemplo e WHERE e.valid AND NOT e.complete AND sarbel_ejemplo.ejemplo_id= e.ejemplo_id ; Nothing earth shattering, but a tool every DBA should be familiar with.