On 06/11/2007, Toni Casueps <[EMAIL PROTECTED]> wrote:
>
> I'm using the PostgreSQL crosstab functions to do something like this:
>
> From this table ...
>
> ax 10
> bx 13
> ay 11
> by 17
>
>
> ... I get:
>
> xy
> a10 11
> b13
I was having the same problem.
I defined a "crosstab definition table" where I declare the things I want
out of crosstab and then I dynamically build views that will add the
needed "AS ct42( )".
Maybe someone else can suggest a better solution ...
Il Tuesday 06 November 2007 13:46:06 Toni C
I'm using the PostgreSQL crosstab functions to do something like this:
From this table ...
ax 10
bx 13
ay 11
by 17
... I get:
xy
a10 11
b13 17
To get the second table I have to specify the field list when I call t
