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