Postgres Pro
Downloads
Home   >   mailing lists

crosstab creating multiple rows for same id - Mailing list pgsql-general

From AI Rumman
Subject crosstab creating multiple rows for same id
Date
Msg-id CAGoODpd4AQZrnq0gWz-je6k1tV69aAG=-n5=7jDnjMJ=hPu9Xw@mail.gmail.com
Whole thread Raw
Responses Re: crosstab creating multiple rows for same id
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Balázs Keresztury
Date:
Subject: restoring to different architecture with WAL
Next
From: akp geek
Date:
Subject: Replication stopped on 9.0.2 after making change to conf file