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).
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
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 Chambers||Date: 2006-04-23 08:52:04|
|Subject: Re: Oracle Analytic Functions for PostreSQL|