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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Arnilo S. Baluyos (Mailing Lists) | 2006-04-24 00:01:36 | Temporarily disable strict UTF-8 checking |
Previous Message | Andrew Chambers | 2006-04-23 08:52:04 | Re: Oracle Analytic Functions for PostreSQL |