On 4 Jun 2016, at 10:15pm, Jean-Christophe Deschamps <[email protected]> wrote:
> Can't the same update be done more efficiently with a CTE? The command inside the WITH has to be a SELECT command. I wonder if there's a good reason for that. If the command inside WITH could make changes to the database the result might be ambiguous, and very sensitive to how the SQL engine works. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
