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

Re: Pet Peeves?

From: Jason Long <jason(at)octgsoftware(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-30 14:16:12
Message-ID: 49830BAC.5010002@supernovasoftware.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

In response to

pgsql-general by date

Next:From: Gregory StarkDate: 2009-01-30 14:25:28
Subject: Re: Pet Peeves?
Previous:From: Grzegorz JaśkiewiczDate: 2009-01-30 14:10:59
Subject: database/table snapshot

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