"Flattening" query result into columns

Поиск
Список
Период
Сортировка
От Thomas Borg Salling
Тема "Flattening" query result into columns
Дата
Msg-id 20050321215723.E79E356388@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: "Flattening" query result into columns  (PFC <lists@boutiquenumerique.com>)
Re: "Flattening" query result into columns  ("Leif B. Kristensen" <leif@solumslekt.org>)
Re: "Flattening" query result into columns  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">I am looking for a way to ”flatten” a query result, so that rows are ”transposed” into
columns,just as asked here for oracle:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"><a
href="http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com">http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401292322.7b6c320b%40posting.google.com</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">Is there any way to do this with pgsql  ?</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">/Thomas.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font></div>

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: query
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: "Flattening" query result into columns