crosstab - Mailing list pgsql-general

From Rosebrock, Uwe (Environment, Hobart)
Subject crosstab
Date
Msg-id 49B02DE1-77FA-4748-AFD6-31F46DC43D38@csiro.au
Whole thread Raw
Responses Re: crosstab  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Next
From: Dominique Devienne
Date:
Subject: public schema grants to PUBLIC role