query

Поиск
Список
Период
Сортировка
От Jodi Kanter
Тема query
Дата
Msg-id 00cd01c28ce8$433dcc60$de138f80@virginia.edu
обсуждение исходный текст
Список pgsql-admin
I have a query that pulls two fields across three tables such that the results 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 exists 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 columns (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 placing 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


 

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Andrés Ruz Salinas
Дата:
Сообщение: More one BDD
Следующее
От: Murthy Kambhampaty
Дата:
Сообщение: PostgreSQL and file system level backup