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... )  ("Daniel Verite" <daniel@manitou-mail.org>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: CROSSTAB( .. only one column has values... )
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Max# of tablespaces