Re: CUBE SYNTAX

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: CUBE SYNTAX
Дата
Msg-id 87sl9fj4j9.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: CUBE SYNTAX  (David Fetter <david@fetter.org>)
Список pgsql-general
"David Fetter" <david@fetter.org> writes:

> On Sun, May 27, 2007 at 01:23:48PM -0400, ABHANG RANE wrote:
>> Hi,
>> I need to use the cube operator in postgresql 8.2. Whats the syntax
>> for the cube or a link to the documentation which clearly explains
>> how to use cube operator syntactically.
>
> There is a contrib module for cube.
>
> <http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/>

I think that's a different meaning of "cube". I think what he's looking for is
the query clause which is like ROLLUP except that it does it on every possible
axis. It's normally used in reporting tools.

If that's what you're looking for then afaik there's no module to do this in
Postgres. Sorry.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: danmcb
Дата:
Сообщение: Re: optimisation for a table with frequently used query
Следующее
От: Kenneth Downs
Дата:
Сообщение: Re: SQL Manager 2007 for PostgreSQL released