Update of /cvsroot/monetdb/sql/src/common
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv13637/src/common
Modified Files:
Tag: SQL_2-16
sql_types.mx
Log Message:
We implemented RANK as ROW_NUMBER which isn't correct afcourse
So now added ROW_NUMBER and a new implementation for RANK.
Index: sql_types.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/common/sql_types.mx,v
retrieving revision 1.78.2.4
retrieving revision 1.78.2.5
diff -u -d -r1.78.2.4 -r1.78.2.5
--- sql_types.mx 31 Mar 2007 17:25:37 -0000 1.78.2.4
+++ sql_types.mx 31 Mar 2007 20:34:02 -0000 1.78.2.5
@@ -1262,7 +1262,11 @@
sql_create_aggr("count_no_nil", "aggr", "count_no_nil", NULL, INT);
sql_create_aggr("count", "aggr", "count", NULL, INT);
- sql_create_aggr("rownumber", "aggr", "mark_grp", NULL, OID);
+ sql_create_aggr("rank", "aggr", "rank_grp", NULL, INT);
+ sql_create_aggr("dense_rank", "aggr", "dense_rank_grp", NULL, INT);
+ sql_create_aggr("percent_rank", "aggr", "precent_rank_grp", NULL, INT);
+ sql_create_aggr("cume_dist", "aggr", "cume_dist_grp", NULL, INT);
+ sql_create_aggr("row_number", "aggr", "mark_grp", NULL, INT);
sql_create_func("and", "calc", "and", BIT, BIT, BIT, SCALE_FIX);
sql_create_func("or", "calc", "or", BIT, BIT, BIT, SCALE_FIX);
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
