Skip site navigation (1) Skip section navigation (2)

Re: Oracle Analytic Functions for PostreSQL

From: "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>
To: "Andrew Chambers" <andychambers2002(at)yahoo(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Oracle Analytic Functions for PostreSQL
Date: 2006-04-23 17:44:38
Message-ID: e431ff4c0604231044t1967998eh6a4fa60600c5e2fd@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)yahoo(dot)co(dot)uk> wrote:
> * Richard Broersma Jr <rabroersma(at)yahoo(dot)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

In response to

pgsql-novice by date

Next:From: Matt Arnilo S. Baluyos (Mailing Lists)Date: 2006-04-24 00:01:36
Subject: Temporarily disable strict UTF-8 checking
Previous:From: Andrew ChambersDate: 2006-04-23 08:52:04
Subject: Re: Oracle Analytic Functions for PostreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group