Igor Tandetnik wrote: > Zack Weinberg <za...@panix.com> wrote: [...] >> Is it possible to do this operation in one SQLite statement? > > insert or replace into observations > values (:src, :dest, :verb, > coalesce( > (select occurrences from observations > where src=:src and dest=:dest and verb=:verb), > 0) + 1);
This works perfectly. Thank you for answering the question. zw _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
