There are many things from SQL:200n that PostgreSQL doesn't support yet.
SQL:200n doesn't have ORA's analytical functions, but it contains some
features that definitely may be useful in creating SQL statements for
data analysis: ROLLUP, CUBE, GROUPING; WITH .. , recursive statements
and so on.
Just for clarity...
On 4/23/06, Andrew Chambers <andychambers2002@yahoo.co.uk> wrote:
> * Richard Broersma Jr <rabroersma@yahoo.com> [2006-04-21 14:13:36 -0700]:
>
> > I'll try to do my best to answer you questions. But you might get a better response on the
> > general mailing list.
> >
> >
> > > It seems that PostgreSQL does not offer the
> > > equivalent (maybe because they do not belong to standard SQL?).
> >
> > >From what I understand, PostgreSQL strongly support Standard SQL.
>
> I think the OP knows that and is suggesting that might be why PostgreSQL
> does not provide the analytic functions he describes. (i.e. the
> functions are not part of the standard).
>
> regards,
> Andy
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Best regards,
Nikolay