RE: [Firebird-devel] Crosstab queries, pivot tables

[Dmitry Y. <di...@us...>]

Adam,

> I don't know if this is the right place for such a question,
> but I don't know who else should I ask
> Could anybody tell me some things about PIVOT tables in
> Firebird? There is a Delphi component
> (TxQuery) which can do crosstab queries TRANSFORM ... PIVOT keywords:
> http://www.sigmap.com/PivotTransform.htm
>
> This could be a veryuseful feature in Firebird if it could do
> that kind of crosstab queries, couldn't it?
> I think other RDMSes (Oracle, etc.) has something like this.
> What about it guys?

Please describe both semantics and syntax for this feature in details and
add the request to our tracker. It would be good if you could also provide
the information how such keywords are handled in Oracle, etc.

> Is it hard to implement such thing in the
> next version of Firebird (maybe in the 1.5 :-))?

Definetely not in v1.5 and probably not in v2.0 either.


Dmitry