Yang Zhang <yanghates...@gmail.com> wrote: > Pavel Ivanov wrote: >> BTW, ACID that you mentioned has nothing to do with snapshot >> isolation that you want to achieve. AFAIK only Oracle supports this >> kind of statement isolation level. > > Actually, Oracle, Postgresql, SQL Server, Firebird, and others support > snapshot isolation. http://en.wikipedia.org/wiki/Snapshot_isolation
... but not between two statements running within _the same transaction_. Isolation level (snapshot or otherwise) describes how two transactions are isolated from each other. In your example, you only have one transaction, so any discussion of isolation levels is moot. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
