On 30 Mar 2018, at 5:55pm, Igor Tandetnik <[email protected]> wrote:
> I don't think that's what the OP had in mind. They didn't want the smaller of > a and b for each row, but rather the lexicographically smallest (a, b) pair > among all rows. > > Row values support less-than comparison, so it kind of makes sense to expect > MIN to work on them, too. Ah. Okay, I get it. The only way I can think of to do it is to devise a metric to turn a pair (a, b) into one number. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
