crosstab creating multiple rows for same id

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: crosstab creating multiple rows for same id
Date: 2013-03-07 22:30:42
Message-ID: CAGoODpd4AQZrnq0gWz-je6k1tV69aAG=-n5=7jDnjMJ=hPu9Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am using the crosstab function in Postgresql 9.0.
The functions works fine when the distinct category value is less. But when
it goes to to higher like 100 or more, it creates multiple rows for the
same rowid.

Any idea about it?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2013-03-08 00:28:40 Replication stopped on 9.0.2 after making change to conf file
Previous Message François Beausoleil 2013-03-07 22:21:32 Making planner skip hard-coded view values?