As an aside, a principle of the relational model is that operations on relations should produce a relation. This caused a bit of a problem early on as if you perform a Project operation ie cut down the number of fields, you can finish up with 'duplicate' rows ie rows that can't be distinguished. RDBMs in practice all use tables instead of relations. Even base tables can contain 'duplicate' records although that would be bad practice.
-- View this message in context: http://www.nabble.com/Statements-that-return-a-result-set--tp24735659p24737576.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users