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.
