Hi Scott, Thanks for the information. This is very useful for me. I will be careful when forming the column.
Thanks, -maria On Tue, Jun 10, 2008 at 3:16 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, Jun 10, 2008 at 11:51 AM, maria s <[EMAIL PROTECTED]> 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. >