|
|
|
|
|
|
by eatonphil
1239 days ago
|
|
|
> not every engine implementing them is another story Which don't? I'd have assumed anything inside of `SELECT`'s `FROM` would be allowed inside of `INSERT` and `UPDATE`. Or maybe you're not saying you know there are implementations that have these restrictions just that any random implementation might not be there (yet). |
|
|
Redshift (a PostgreSQL derivative, more or less) can run an INSERT with a join, but cannot do an UPDATE with a join.