From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: Postgres v MySQL 5.0 |
Date: | 2006-11-06 18:55:11 |
Message-ID: | 200611061055.11699.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2006-11-06 18:58:14 | Re: Need replacement booth member for USENIX Lisa |
Previous Message | Alvaro Herrera | 2006-11-06 17:46:41 | Re: On what we want to support: travel? |