Jean-Christophe Deschamps wrote: > What suprises me is that a select of 1 field yields a field (not a > 1-tuple containing 1 field) but then a select of n > 1 fields yields a > n-tuple, not a sequence of n fields.
A sub-select returning more than one column or one row is actually illegal when used as a term in an expression. Most DBMS raise an error if you try this. SQLite tolerates this violation by picking the first column from the first row as the value of such an expression. There is no n-tuple here. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
