-----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-----