https://www.sqlite.org/rowvalue.html section 2.1 for ordering.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] 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 <peter.dasi...@flightaware.com> wrote: > On 3/30/18, 11:58 AM, "sqlite-users on behalf of Simon Slavin" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of > slav...@bigfraud.org> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
