Hi,
Row values make life easier in so many ways, but I was just wondering if
there is (or should be or could be) a way to use aggregate MIN() and
MAX() on a set of row values.
Mark
CREATE TABLE T (a, b);
INSERT INTO T (a, b) VALUES (1, 2), (1, 3), (2, 3);
SELECT MIN((a,b)) = (1, 2) ok FROM T;
--Error: near line 4: row value misused
SELECT MIN((SELECT a, b)) = (1, 2) ok FROM T;
--Error: near line 7: row value misused
SELECT (1, 2) = MIN(SELECT a, b FROM T);
--Error: near line 10: near "SELECT": syntax error
--ok
SELECT T.*
FROM T
LEFT JOIN T S
ON (S.a, S.b) < (T.a, T.b)
WHERE S.a IS NULL;
--ok
SELECT (T.a, T.b) = (1, 2) ok
FROM T
LEFT JOIN T S
ON (S.a, S.b) < (T.a, T.b)
WHERE S.a IS NULL;
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
