Re: Generating a cross tab (pivot table)

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Generating a cross tab (pivot table)
Дата
Msg-id 200211071215.32235.dev@archonet.com
обсуждение исходный текст
Ответ на Generating a cross tab (pivot table)  (Christoph Haller <ch@rodos.fzk.de>)
Список pgsql-sql
On Thursday 07 Nov 2002 11:47 am, Christoph Haller wrote:
> Regarding to Terry's request on multiple aggregates and
> Shahbaz's request for generating a cross tab ( pivot table )
> in September, I've found an excellent example on a german inet page
> http://www.itrain.de/
> I've translated it and think it's useful for many who subscribed
> (I hope so, maybe it was told before, but I couldn't find
> anything about this topic in the techdecs).

Very useful. Also note there are some examples of how to produce crosstab
results in the table-functions contrib directory in 7.3

--  Richard Huxton


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

Предыдущее
От: "Nekta Katz"
Дата:
Сообщение: cast lo to oid
Следующее
От: terry@greatgulfhomes.com
Дата:
Сообщение: Re: query optimization question