15 Apr
2010
15 Apr
'10
11:32 a.m.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Op 15-04-10 13:27, Nafees Ur Rehman schreef:
Whats is the syntax of grouping sets in monetdb? I am trying /Select has_nurs,form,health,class,count(*) from nursery group by GROUPING SETS ((has_nurs,class),(form,class),(health,class))/ but it does not work
It does not seem to be defined in SQL92 http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt, thus it is not (yet) supported. Probably the best thing to do is to add a feature request on Sourceforge for it.
Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAkvG+UIACgkQYH1+F2Rqwn31ZQCfSDtyCIemTtoGhK7l0JrpueUg
YbgAnjwB/1FCJCymKzik1gLlQnfqcOA0
=/igd
-----END PGP SIGNATURE-----