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: (view raw, whole thread or download thread mbox)
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:
> As for Oracle, it wasn't possible until recently but now 11g has the 
> PIVOT clause:
> 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-2018 The PostgreSQL Global Development Group