Re: help in writing query

On Tue, Jun 10, 2008 at 11:51 AM, maria s <psmg01(at)gmail(dot)com> wrote:
> Hi Rosario,
> Thanks for the link. I hope this will solve my problem.

It should be able to. Note that crosstab functions expect "square"
inputs from the select they run. I.e. you can't have empty columns,
you need to replace NULL output with something like a space or empty
string.

This is bad input for crosstab:

col1 col2 col3
1 2 3
2 3 NULL
3 NULL 6

But this will work:

col1 col2 col3
1 2 3
2 3 '' <- an empty string
3 '' 6

The crosstab functions are wonderfully useful btw, once you figure all
the little quirks like this out.