crosstab creating multiple rows for same id

[AI Rumman <rummandba@xxxxxxxxx>]

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.