[MonetDB-users] Windowing functions ?
Hello everyone,
After visiting the MonetDB website, I didn't saw any information about the windowing functions of SQL (ranking, selecting max according to a defined order, etc.)
A (very) short introduction can be found on wikipedia: http://en.wikipedia.org/wiki/Select_%28SQL%29#Window_function
I know it is implemented into PostGreSQL, Oracle and Microsoft SQL Server. Is there any chance to see this function in MonetDB in the future ?
Thanks in advance, sorry for my poor english ... :(
Fabian Pijcke
On Wed, Jun 15, 2011 at 11:05:43PM +0200, Fabian Pijcke wrote:
Hello everyone,
After visiting the MonetDB website, I didn't saw any information about the windowing functions of SQL (ranking, selecting max according to a defined order, etc.)
A (very) short introduction can be found on wikipedia: http:// en.wikipedia.org/wiki/Select_%28SQL%29#Window_function
I know it is implemented into PostGreSQL, Oracle and Microsoft SQL Server. Is there any chance to see this function in MonetDB in the future ?
Thanks in advance, sorry for my poor english ... :(
we support the 'OVER' clause. Currently no 'window' registration is possible.
Niels
Fabian Pijcke
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Thank you for your fast answer :-)
I didn't found any documentation over this construction, isn't it documented ? It's indeed a good news for me, MonetDB seems to be a so nice SGBDR !
Thank you again !
Fabian Pijcke
2011/6/15 Niels Nes Niels.Nes@cwi.nl
On Wed, Jun 15, 2011 at 11:05:43PM +0200, Fabian Pijcke wrote:
Hello everyone,
After visiting the MonetDB website, I didn't saw any information about the windowing functions of SQL (ranking, selecting max according to a defined order, etc.)
A (very) short introduction can be found on wikipedia: http:// en.wikipedia.org/wiki/Select_%28SQL%29#Window_function
I know it is implemented into PostGreSQL, Oracle and Microsoft SQL Server. Is there any chance to see this function in MonetDB in the future ?
Thanks in advance, sorry for my poor english ... :(
we support the 'OVER' clause. Currently no 'window' registration is possible.
Niels
Fabian Pijcke
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Fabian Pijcke
-
Niels Nes