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

Hi Rosario,<br />Thanks for the link. I hope this will solve my problem.<br /><br />Thanks,<br />Maria<br /><br /><div
class="gmail_quote">OnTue, Jun 10, 2008 at 11:34 AM, Osvaldo Rosario Kussama <<a
href="mailto:osvaldo.kussama@gmail.com">osvaldo.kussama@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;">maria s escreveu:<div
class="Ih2E3d"><br/><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt
0pt0.8ex; padding-left: 1ex;"><br /> I tried the query and it is returning result as ,<br /> for a single entry in
sampleinfo in separate rows<br /><br /> The result of the query as<br /><br /> 1, prop1,value1<br /> 1,prop2,value2<br
/>2,prop1,value1<br /> 2 prop2,value2<br /> 2 prop3,value3<br /><br /> but i want the output as single row per sample
idlike<br /><br /> 1,value1,value2<br /> 2 value1,value2,value3<br /><br /> Is this possible? or functions will help to
getthe result?<br /></blockquote><br /></div> Try tablefunc/crosstab:<br /><a
href="http://www.postgresql.org/docs/current/interactive/tablefunc.html"
target="_blank">http://www.postgresql.org/docs/current/interactive/tablefunc.html</a><br/><br /><br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br
/>please help.<br /><br /> Thanks,<br /> -maria<div class="Ih2E3d"><br /><br /> On Tue, Jun 10, 2008 at 11:03 AM, Pavel
Stehule<<a href="mailto:pavel.stehule@gmail.com" target="_blank">pavel.stehule@gmail.com</a> <mailto:<a
href="mailto:pavel.stehule@gmail.com"target="_blank">pavel.stehule@gmail.com</a>>> wrote:<br /><br />    Hello<br
/><br/></div>    SELECT <a href="http://i.name" target="_blank">i.name</a> <<a href="http://i.name"
target="_blank">http://i.name</a>>,p.property_name, p.property_value<div class="Ih2E3d"><br />      FROM sample_info
i<br/>                JOIN<br />                sample_properties p<br /></div>                ON <a href="http://i.id"
target="_blank">i.id</a><<a href="http://i.id" target="_blank">http://i.id</a>> = <a href="http://p.id"
target="_blank">p.id</a><<a href="http://p.id" target="_blank">http://p.id</a>><br /><br />    maybe<br />  
 Pavel<br/><br />    2008/6/10 maria s <<a href="mailto:psmg01@gmail.com" target="_blank">psmg01@gmail.com</a>
<mailto:<ahref="mailto:psmg01@gmail.com" target="_blank">psmg01@gmail.com</a>>>:<div class="Ih2E3d"><br />    
>Hello friends,<br />     > I need help in write a query.<br />     ><br />     > I have 2 tables, one is
sample_infoand sample_properties,<br />     ><br />     > sample_info (id integer, string name)<br />     >
------------------<br/>     > 1, c_01<br />     > 2, c_02<br />     > ...<br />     ><br />     >
sample_properties(sample_idinteger(ref. sample_info),<br />    property_name string<br />     > ,property_value
string)<br />     > -------------------------<br />     > 1, prop1, value1<br />     > 1, prop2, value2<br />
   > 2, prop1, value1<br />     > 2, prop2, value 2<br />     > 2, prop3, value3<br />     ><br />    
><br/>     > I would like to get the result by joining 2 tables,  for sample<br />    id 1 from<br />     >
sample_info,the result should be<br />     ><br />     > 1,c_01,value1,value2<br />     ><br />     > for
sample2<br />     ><br />     > 2, c_02,value1,value2,value3<br />     ><br />     > with property_value
columnheader as property_name<br />     ><br />     > Can anyone help me to write a query /function/view to get
the<br/>    above output?<br />     ><br /></div></blockquote><font color="#888888"><br /> Osvaldo<br
/></font></blockquote></div><br/>