From CROSSTAB: One Column data with Two results columns - Mailing list pgsql-admin

Hi,

I am working CROSSTAB functionality to generate the reports in the CSV format.

Now I have stage where I need to generate 2 result sets  for the same 1 column data.

I am sharing the example here.

I have attached a sample data file.

I am trying to know if I can generate this type of SQl ressult using CROSSTAB . I appreciate any hint or comments on this.

Thanks a lot,

Sarwar