Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 53000475C60 for ; Fri, 15 Nov 2002 15:44:58 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 64A05475B84 for ; Fri, 15 Nov 2002 15:44:57 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa12809; 15 Nov 2002 15:44 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.6/8.11.6) with SMTP id gAFKisr08102 for ; Fri, 15 Nov 2002 15:44:54 -0500 Message-ID: <00cd01c28ce8$433dcc60$de138f80@virginia.edu> From: Jodi Kanter To: Postgres Admin List Subject: query Date: Fri, 15 Nov 2002 15:47:50 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CA_01C28CBE.5A493FE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/167 X-Sequence-Number: 6355 This is a multi-part message in MIME format. ------=_NextPart_000_00CA_01C28CBE.5A493FE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a query that pulls two fields across three tables such that the resu= lts are in two columns: layout.probe spot.signal value1 some value value2 some value value3 some value value1 some value value2 some value value3 some value I have three tables: spot, measurement, layout. The measurement table ex= ists in the query because it sits between the spot and layout tables which = hold the data that I want. My goal is to produce a report that lists the signal values in separate col= umns (instead of having the probe value repeat) such that the results look = like this: layout.probe signal signal value1 some value some value value2 some value some value value3 some value some value What is the most efficient way to do this? I assume it would require placin= g the data in temporary tables? Is there some complicate query design that = could handle this? Please contact me if my description is not clear. Thank you Jodi _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu =20 =20 =20 ------=_NextPart_000_00CA_01C28CBE.5A493FE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I have a query that pulls two fields ac= ross=20 three tables such that the results are in two columns:

layout.probe &= nbsp; =20 spot.signal

value1 &n= bsp; =20 some value

value2 &n= bsp; =20 some value

value3 &n= bsp; =20 some value

value1 &n= bsp; =20 some value

value2 &n= bsp; =20 some value

value3 &n= bsp; =20 some value

I have three tables: = spot,=20 measurement, layout. The measurement table exists in the query because it s= its=20 between the spot and layout tables which hold the data that I want.<= /DIV>

My goal is to produce a report that lis= ts the=20 signal values in separate columns (instead of having the probe value repeat= )=20 such that the results look like this:

layout.probe = =20 signal =20 =20 signal

value1 &n= bsp; = ;some=20 value some value

value2 &n= bsp;=20 some=20 value some value

value3 &n= bsp;=20 some=20 value some value

What is the most efficient way to do th= is? I=20 assume it would require placing the data in temporary tables? Is there some= =20 complicate query design that could handle this?

Please contact me if my description is = not=20 clear.

Thank you

Jodi

_______________________________
Jodi=20 L Kanter
BioInformatics Database Administrator
University of=20 Virginia
(434) 924-2846
jkanter@virginia.edu

<= /DIV> ------=_NextPart_000_00CA_01C28CBE.5A493FE0--