On Wed, Aug 02, 2017 at 06:46:55PM +0000, Sylvain Pointeau wrote:
> if I do
>
> insert into mytable(f)
> select nextval("myseq") from T
>
> is it really possible to make an update into that nextval function? I don't
> think so since only one statement can be run at the same time if sqlite is
> in serialized mode.
Yes, UDFs can run arbitrary SQL statements on the same connection.
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
