Re: Oracle Analytic Functions for PostreSQL - Mailing list pgsql-novice

From Nikolay Samokhvalov
Subject Re: Oracle Analytic Functions for PostreSQL
Date
Msg-id e431ff4c0604231044t1967998eh6a4fa60600c5e2fd@mail.gmail.com
Whole thread Raw
In response to Re: Oracle Analytic Functions for PostreSQL  (Andrew Chambers <andychambers2002@yahoo.co.uk>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Andrew Chambers
Date:
Subject: Re: Oracle Analytic Functions for PostreSQL
Next
From: "Matt Arnilo S. Baluyos (Mailing Lists)"
Date:
Subject: Temporarily disable strict UTF-8 checking