crosstab

Поиск
Список
Период
Сортировка
От Rosebrock, Uwe (Environment, Hobart)
Тема crosstab
Дата
Msg-id 49B02DE1-77FA-4748-AFD6-31F46DC43D38@csiro.au
обсуждение исходный текст
Ответы Re: crosstab
Список pgsql-general

Hi List

I like to use crosstab to pivot a long list of rows into columns, however the column labels are created dynamically with the resulting column type known.

 

Is there a way pass a list of names and types to crosstab (‘query’) as (<‘type list as strings in array’> ) ?

In other words,

Can I pass an array to crosstab row labels

 

Cheers

Uwe

 

 

 

 

 

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