On Mon, Feb 24, 2003 at 07:37:21PM -0800, DiAnNe iRiS aLeRta wrote: > i am to make a feature for mysql which is horizontal aggregation for our thesis. > > is this existing already? if not, is vertical aggregation existing? > can you show me the codes for it? i need it to have a basis for > developing the horizontal aggregation. > > horizontal aggregation is collecting values in a ROW based on some > grouping criterion and displaying it in horizontal manner. vertical > aggregation is collecting values in a COLUMN based on some grouping > criterion. > thank you so much!
Dear Dianne, MySQL supports vertical aggregation. Review http://www.mysql.com/doc/en/Group_by_functions.html As for finding the code that relates to these functions, the best place to start (IMHO :) is by grabbing a copy of cscope and then starting to dig into the code at sql/sql_yacc.yy cscope allows you to interactively browse though C source code (but can also handle C++ well enough) - if you don't have a copy, grab one from http://cscope.sourceforge.net/ Good Luck! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Translucent Databases: An Excellent Guide to Protecting Sensitive Data! Visit http://www.wayner.org/books/td/ for more information --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php