Re: CROSSTAB( .. only one column has values... )
| От | Pavel Stehule |
|---|---|
| Тема | Re: CROSSTAB( .. only one column has values... ) |
| Дата | |
| Msg-id | CAFj8pRBzHJG5==nZGxS6RMSMR_zYNCAJawWtSKq11aRE+f8qCQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CROSSTAB( .. only one column has values... ) (Joe Conway <mail@joeconway.com>) |
| Ответы |
Re: CROSSTAB( .. only one column has values... )
|
| Список | pgsql-general |
Hi
út 5. 1. 2021 v 19:45 odesílatel Joe Conway <mail@joeconway.com> napsal:
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!
Regards
Pavel
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
В списке pgsql-general по дате отправления: