Request a Demo
Home   >   mailing lists

Re: CROSSTAB( .. only one column has values... ) - Mailing list pgsql-general

From Joe Conway
Subject Re: CROSSTAB( .. only one column has values... )
Date
Msg-id a0b93b67-eaf1-0d3d-1a97-37ba578e6a4b@joeconway.com
Whole thread Raw
In response to Re: CROSSTAB( .. only one column has values... )  (Tim Clarke <tim.clarke@minerva.info>)
Responses Re: CROSSTAB( .. only one column has values... )
List pgsql-general
Tree view 
On 1/5/21 12:11 PM, Tim Clarke wrote:
> imho the crosstab() function isn't a good implementation. The biggest failure it
> has is that you must know exactly how many output columns you will have in the
> result /_prior to running it


*That* is a function of how Postgres set returning functions work, and not
specific to crosstab(). It is not easily fixed. Patches to fix that would be
welcomed!

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachment

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: CROSSTAB( .. only one column has values... )
Next
From: Joe Conway
Date:
Subject: Re: CROSSTAB( .. only one column has values... )