Re: [GENERAL] crosstab creating multiple rows for same id

2013-03-09 Thread David Johnston
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

[GENERAL] crosstab creating multiple rows for same id

2013-03-07 Thread AI Rumman
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.