Postgres Pro
Downloads
Home   >   mailing lists

Thread: crosstab

crosstab

From
"Rosebrock, Uwe (Environment, Hobart)"
Date:

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

 

 

 

 

 

Re: crosstab

From
"David G. Johnston"
Date:


On Wednesday, March 8, 2023, Rosebrock, Uwe (Environment, Hobart) <Uwe.Rosebrock@csiro.au> wrote:

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


No, you cannot change query structure at execution time in SQL.

David J.