https://www.sqlite.org/rowvalue.html section 2.1 for ordering.
-----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Simon Slavin Sent: Friday, March 30, 2018 1:06 PM To: SQLite mailing list Subject: Re: [sqlite] MIN() and MAX() of set of row values On 30 Mar 2018, at 6:04pm, Peter Da Silva <[email protected]> wrote: > On 3/30/18, 11:58 AM, "sqlite-users on behalf of Simon Slavin" > <[email protected] on behalf of > [email protected]> wrote: >> can think of to do it is to devise a metric to turn a pair (a, b) into one >> number. > > Problem is you can't uniquely order pairs of points. Is (1, 2) greater or > lesser than (2, 1)? That's up to you. That's why you are devising the metric. Maybe the metric is just score == a + b . Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
