[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-users
Subject: Re: [MonetDB-users] Windowing functions ?
From: Fabian Pijcke <fabian.pijcke () gmail ! com>
Date: 2011-06-15 22:12:25
Message-ID: BANLkTimo9pBD7ohKQeBi7OVptiHT+-TkpA () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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
>
>
[Attachment #5 (text/html)]
Thank you for your fast answer :-)<br><br>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 !<br><br>Thank you again !<br> <br>Fabian \
Pijcke<br><br><div class="gmail_quote">2011/6/15 Niels Nes <span dir="ltr"><<a \
href="mailto:Niels.Nes@cwi.nl">Niels.Nes@cwi.nl</a>></span><br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex;"> <div><div></div><div class="h5">On Wed, Jun 15, 2011 at \
11:05:43PM +0200, Fabian Pijcke wrote:<br> > Hello everyone,<br>
><br>
> After visiting the MonetDB website, I didn't saw any information about<br>
> the windowing functions of SQL (ranking, selecting max according to a<br>
> defined order, etc.)<br>
><br>
> A (very) short introduction can be found on wikipedia: http://<br>
> <a href="http://en.wikipedia.org/wiki/Select_%28SQL%29#Window_function" \
target="_blank">en.wikipedia.org/wiki/Select_%28SQL%29#Window_function</a><br> \
><br> > I know it is implemented into PostGreSQL, Oracle and Microsoft SQL<br>
> Server. Is there any chance to see this function in MonetDB in the<br>
> future ?<br>
><br>
> Thanks in advance, sorry for my poor english ... :(<br>
<br>
</div></div>we support the 'OVER' clause. Currently no 'window' \
registration is<br> possible.<br>
<br>
Niels<br>
><br>
> Fabian Pijcke<br>
<br>
> ------------------------------------------------------------------------------<br>
> EditLive Enterprise is the world's most technically advanced content<br>
> authoring tool. Experience the power of Track Changes, Inline Image<br>
> Editing and ensure content is compliant with Accessibility Checking.<br>
> <a href="http://p.sf.net/sfu/ephox-dev2dev" \
target="_blank">http://p.sf.net/sfu/ephox-dev2dev</a><br> <br>
> _______________________________________________<br>
> MonetDB-users mailing list<br>
> <a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
> <a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br> \
<font color="#888888"><br> <br>
--<br>
Niels Nes, Centrum Wiskunde & Informatica (CWI)<br>
Science Park 123, 1098 XG Amsterdam, The Netherlands<br>
room L3.14, phone ++31 20 592-4098 <a \
href="mailto:sip%3A4098@sip.cwi.nl">sip:4098@sip.cwi.nl</a><br>
url: <a href="http://www.cwi.nl/%7Eniels" \
target="_blank">http://www.cwi.nl/~niels</a> e-mail: <a \
href="mailto:Niels.Nes@cwi.nl">Niels.Nes@cwi.nl</a><br> \
</font><br>------------------------------------------------------------------------------<br>
EditLive Enterprise is the world's most technically advanced content<br>
authoring tool. Experience the power of Track Changes, Inline Image<br>
Editing and ensure content is compliant with Accessibility Checking.<br>
<a href="http://p.sf.net/sfu/ephox-dev2dev" \
target="_blank">http://p.sf.net/sfu/ephox-dev2dev</a><br>_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br> \
<br></blockquote></div><br>
------------------------------------------------------------------------------
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic