Alexandre,

> -----Original Message-----
> From: Firebird-Architect@yahoogroups.com [mailto:Firebird-
> Architect@yahoogroups.com] On Behalf Of Alexandre Benson Smith
> Sent: Tuesday, June 19, 2007 5:19 PM
> To: Firebird-Architect@yahoogroups.com
> Subject: Re: [Firebird-Architect] Re: Window functions SQL-2003
>
> amoradell wrote:
> > When you see for the first time these queries, you say :
> > euh...c'est quoi ca !
> >
> > Window functions are really useful when you make complex

aggregations

> > for reports and olap.
> >
> > Alexandre
> >
>
> This is not what the new "Table expressions" are for ?

I was thinking the same thing, but they are different. The "Window
Functions" define a separate syntax.

I suspect that the current functionality for the Common Table
Expressions, could be used as the basis for the functions which have
been requested.


Sean