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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql