Changeset: 71ab506b9964 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/71ab506b9964
Modified Files:
sql/test/nested/Tests/basic.test
Branch: nested
Log Message:
add aggregate example
diffs (15 lines):
diff --git a/sql/test/nested/Tests/basic.test b/sql/test/nested/Tests/basic.test
--- a/sql/test/nested/Tests/basic.test
+++ b/sql/test/nested/Tests/basic.test
@@ -30,3 +30,11 @@ 2
3
{2,3,4}
4
+
+query TI nosort
+select f1, avg(f.elements) from arr_tbl, unnest(f1) f group by f1;
+----
+{1,2,3}
+2
+{2,3,4}
+3
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]