Changeset: 858aa951d7a4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=858aa951d7a4
Modified Files:
clients/mapiclient/mhelp.c
Branch: grouping-analytics
Log Message:
Updated mhelp
diffs (33 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -433,14 +433,14 @@ SQLhelp sqlhelp1[] = {
"[ FROM from_item [',' ...] ]\n"
"[ WINDOW window_definition [',' ...] ]\n"
"[ WHERE condition ]\n"
- "[ GROUP BY expression [',' ...] ]\n"
+ "[ GROUP BY group_by_element [',' ...] ]\n"
"[ HAVING condition [',' ...] ]\n"
"[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] [ CORRESPONDING ]
select ]\n"
"[ ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [','
...] ]\n"
"[ LIMIT { count | param } ]\n"
"[ OFFSET { count | param } ]\n"
"[ SAMPLE size [ SEED size ] ]",
- "cte_list,expression,window_definition",
+ "cte_list,expression,group_by_element,window_definition",
"See also
https://www.monetdb.org/Documentation/SQLreference/TableExpressions"},
{"SET",
"Assign a value to a variable or column",
@@ -629,6 +629,12 @@ SQLhelp sqlhelp2[] = {
"{ PUBLIC | authid } ",
"authid",
NULL},
+ {"group_by_element",
+ NULL,
+ "{ expression | '(' ')' | ROLLUP '(' ident [',' ... ] ')' | CUBE '('
ident [',' ... ] ')'\n"
+ "| GROUPING SETS '(' group_by_element [',' ... ] ')' }",
+ "expression",
+ NULL},
{"headerlist",
NULL,
"'(' { ident [string] } [',' ...] ')'",
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
