Postgres Pro
Downloads
Home   >   mailing lists

Thread: crosstab creating multiple rows for same id

crosstab creating multiple rows for same id

From
AI Rumman
Date:
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.

Re: crosstab creating multiple rows for same id

From
David Johnston
Date:
you provide inadequate information to provide anything more than a guess...

Are you sure your issue isn't simply a client display consideration -
basically word-wrapping?

David J.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/crosstab-creating-multiple-rows-for-same-id-tp5747865p5747883.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.