When using CTEs the rowid is null. The following returns "--NULL--"
.null --NULL--
with c(x) as (select 1)
select rowid from c;
RP
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

