[GENERAL] How can I correctly handle sparse crosstabs?

2014-02-26 Thread Rob Richardson
It seems that crosstab queries assume there is going to be a value for every possible row in the source query. That's not what I have, and I am not getting the result I need. Here is the definition of my source table: CREATE TABLE plc_values ( plc_values_key bigserial NOT NULL,

Re: [GENERAL] How can I correctly handle sparse crosstabs?

2014-02-26 Thread Joe Conway
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/26/2014 07:56 AM, Rob Richardson wrote: It seems that crosstab queries assume there is going to be a value for every possible row in the source query. That?s not what I have, and I am not getting the result I need. snip There is no