Daniel Verite wrote:
Gregory Stark wrote:
Is it the hierarchical query ability you're looking for or pivot?
The former we are actually getting in 8.4.
AFAIK even in systems with pivot you still have to
declare a fixed list of columns in advance anyways.
Do you see a system where it works differently?
MS-Access SQL has a TRANSFORM clause that allows for crosstab queries
without the need to know in advance the number of columns:
http://msdn.microsoft.com/en-us/library/bb208956.aspx
As for Oracle, it wasn't possible until recently but now 11g has the
PIVOT clause:
http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-f
eatures/11g-pivot.html
In contrast of these clauses, PG's contrib/tablefunc looks more
limited and quite harder to use.
Best regards,
The PIVOT clause would kick ass.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
