Re: Postgres v MySQL 5.0

Stig,

> However, currently i miss the following in PG:
> SQL such as: GROUPING SETS, CUBE, ROLLUP. Also looking for WITH RECURSION
> for recursive SQL-queries.

yep, you and everyone else.  Windowing aggregates are a big TODO.   WITH
RECURSION was supposed to be done by Jonah Harris for 8.2 but he bailed.
Take a look at the CUBE contrib module for 8.2, it's enhanced.

> a very handy thing in mysql is FEDERATED tables that allows one to open a
> channel from one MySQL-server to another MySQL-server. Does PG have
> anything similar?

Yes, and for far more than MySQL covers:

dblink:  /contrib/tablefunc in your PostgreSQL source
dbi-link: http://pgfoundry.org/projects/dbi-link
   (note that this allows connecting to *any* tabular data source)
oracle link: http://pgfoundry.org/projects/oralink
mssql link: http://pgfoundry.org/projects/dblink-tds/

--
Josh Berkus
PostgreSQL @ Sun
San Francisco