Postgres Pro
Downloads
Home   >   mailing lists

Thread: CUBE SYNTAX

CUBE SYNTAX

From
ABHANG RANE
Date:
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.

Thanks
Abhang

Re: CUBE SYNTAX

From
Michael Glaesemann
Date:
On May 27, 2007, at 12:23 , ABHANG RANE wrote:

> 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.

PostgreSQL does not have a native CUBE operator. There may be an
extension out there somewhere that provides the functionality, but
I'm not aware of one.

The full documentation for 8.2 is available online at http://
www.postgresql.org/docs/8.2/interactive/index.html

Michael Glaesemann
grzm seespotcode net

Re: CUBE SYNTAX

From
David Fetter
Date:
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/>

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

Re: CUBE SYNTAX

From
Gregory Stark
Date:
"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