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

Re: Oracle Analytic Functions for PostreSQL

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Oracle Analytic Functions for PostreSQL
Date: 2006-04-21 21:13:36
Message-ID: 20060421211336.39929.qmail@web31802.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

This a quote taken from http://www.postgresql.org/about/

"
PostgreSQL prides itself in standards compliance. Its SQL implementation strongly conforms to the
ANSI-SQL 92/99 standards. It has full support for subqueries (including subselects in the FROM
clause), read-committed and serializable transaction isolation levels. And while PostgreSQL has a
fully relational system catalog which itself supports multiple schemas per database, its catalog
is also accessible through the Information Schema as defined in the SQL standard. 
"

> If I am 
> wrong thanks for letting me know where in the docs I can find  details. 
> Otherwise, are you aware of an open-source project (maybe a  corporation) 
> offering a set of equivalent functions ?

I understand that enterpriseDB is a PostgreSQL RDBMS that closly supports Oracle code.  Perhaps it
might have what you are looking for if the standard version of PostgreSQL does not.

http://www.enterprisedb.com/

Regards,

Richard Broersma Jr.

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-04-21 21:49:14
Subject: Re: need help
Previous:From: Jean-Christophe RouxDate: 2006-04-21 20:57:57
Subject: Oracle Analytic Functions for PostreSQL

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