Re: help in writing query - Mailing list pgsql-sql

From maria s
Subject Re: help in writing query
Date
Msg-id d9d42a0f0806101251j79812d87hea0ae13867d4a0b5@mail.gmail.com
Whole thread Raw
In response to Re: help in writing query  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
Hi Scott,<br />Thanks for the information. This is very useful for me.<br />I will be careful when forming the column.
<br/><br />Thanks,<br />-maria<br /><br /><div class="gmail_quote">On Tue, Jun 10, 2008 at 3:16 PM, Scott Marlowe
<<ahref="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>> wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On
Tue,Jun 10, 2008 at 11:51 AM, maria s <<a href="mailto:psmg01@gmail.com">psmg01@gmail.com</a>> wrote:<br /> >
HiRosario,<br /> > Thanks for the link. I hope this will solve my problem.<br /><br /></div>It should be able to.
 Notethat crosstab functions expect "square"<br /> inputs from the select they run.  I.e. you can't have empty
columns,<br/> you need to replace NULL output with something like a space or empty<br /> string.<br /><br /> This is
badinput for crosstab:<br /><br /> col1 col2 col3<br /> 1 2 3<br /> 2 3 NULL<br /> 3 NULL 6<br /><br /> But this will
work:<br/><br /> col1 col2 col3<br /> 1 2 3<br /> 2 3 '' <- an empty string<br /> 3 '' 6<br /><br /> The crosstab
functionsare wonderfully useful btw, once you figure all<br /> the little quirks like this out.<br
/></blockquote></div><br/> 

pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: help in writing query
Next
From: "Medi Montaseri"
Date:
Subject: Re: Conceptual Design Question