crosstab issue

From: Eugenio Trumpy <frippe12573(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: crosstab issue
Date: 2016-07-20 07:33:00
Message-ID: DB3PR06MB08733D5962B99896C8C10353E5080@DB3PR06MB0873.eurprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I was just tying to perform a crosstab query on pgsql 9.1.4.

I wonder if there is something to know for creating a pivot table by using crosstab when the pivot table has more then ten fields.

I prepared crosstab query that aggregate less than 10 fields correctly whilst another crosstab query which put together more than 10 fields

give me problem:

a field put as sixth field in the query results 17th, or field put as 17 that results 8th....it seems that field over 9th is put as first (in the beginning)

and not as last.

Of course there could be something wrong in my query, here reported:

http://paste.ubuntu.com/20045481/

Any hint is welcome.

Regards

E.

Browse pgsql-general by date

  From Date Subject
Next Message Jordan Gigov 2016-07-20 11:34:06 Enhansement proposal: ordering by parameter
Previous Message Craig Ringer 2016-07-20 07:18:43 Re: BDR Cluster vs DB Config