On 30/03/18 18:55, Igor Tandetnik wrote:
<snip>
Row values support less-than comparison, so it kind of makes sense to
expect MIN to work on them, too.
That's what I was thinking too. One would expect aggregate MIN() and
MAX() to work over row values.
While we're on the subject of row values, the error on the first query
below seems unexpected:
sqlite> select (2, 3) = (select (2, 3));
Error: row value misused
sqlite> select (2, 3) = (2, 3);
1
sqlite> select (2, 3) = (values(2, 3));
1
Mark
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users