Nope, that's exactly what I use when I really need it, generalized to simple table/PK schemes.[1] At first I wanted to try and do it within PL/pgSQL (e.g., fro

Nope, that's exactly what I use when I really need it, generalized to simple table/PK schemes.[1] At first I wanted to try and do it within PL/pgSQL (e.g., from your SO link), but I couldn't figure out how to generalize it like I could with my the UPDATE ... INSERT WHERE. (I haven't really studied PL/pgSQL too hard yet.) [1] - https://github.com/BurntSushi/nfldb/blob/master/nfldb/db.py#L344 https://github.com/BurntSushi/nfldb/blob/master/nfldb/db.py#...