Re: PIVOT tables and crosstab

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PIVOT tables and crosstab
Дата
Msg-id 20091211010224.GQ15554@alvh.no-ip.org
обсуждение исходный текст
Ответ на PIVOT tables and crosstab  (Simon Windsor <simon.windsor@cornfield.me.uk>)
Ответы Re: PIVOT tables and crosstab  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Simon Windsor wrote:

> Are there any plans to embed crosstab within the main release of
> Postgres, rather than as a Contrib component.
>
> Also, are there plans to enhance crosstab along the lines of Oracle 11g
> of pivot command?

I think the standard spelling of this feature is GROUPING SETS along
with syntactical sugar CUBE and ROLLUP.  There was a patch for this
posted some time ago but it doesn't look like it has moved forward
lately.

Barring GROUPING SETS, it is very unlikely that crosstab or pivot are
going to make it into the core.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Excessive (and slow) fsync() within single transaction
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Excessive (and slow) fsync() within single transaction