So I'm trying to update table A from values in table B using a join. Should be simple right..
update foo, bar set foo.col = bar.col where foo.bar = bar.id
works in mysql and most real databases
but postgres requires you jump through hoops and still screws it up
update task set category = c.category from task t, command c where t.command = c.id;
doesn't set category in task to be category from the matching command, it sets them all to the first category it meets