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:
> As for Oracle, it wasn't possible until recently but now 11g has the
> PIVOT clause:
> 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 Stark||Date: 2009-01-30 14:25:28|
|Subject: Re: Pet Peeves?|
|Previous:||From: Grzegorz Jaśkiewicz||Date: 2009-01-30 14:10:59|
|Subject: database/table snapshot|