Re: Cube/Rollup/ and Connect by prior - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Cube/Rollup/ and Connect by prior
Date
Msg-id F95F14D2-E6A0-4183-8AF8-29F51FAB5E0E@myrealbox.com
Whole thread Raw
In response to Cube/Rollup/ and Connect by prior  (Shawn Garbett <shawn_garbett@yahoo.com>)
List pgsql-general
On Jan 13, 2006, at 23:27 , Shawn Garbett wrote:

> In oracle there is the idea of group by functions,
> i.e. cube and rollup that are very useful for
> reporting. I've not found an equivalent in PostgreSQL.
> What's the status of this? Can I write my own?

As far as I know, CUBE and ROLLUP haven't been implemented into
PostgreSQL.

> Connect by Prior is a recursive query function for
> navigating tree data structures in oracle, i.e A Table
> that has many of itself. Is there any equivalent in
> PostgreSQL?

Check out tablefunc in the contrib directory. (contrib/tablefunc) I
believe that should do what you want.

Hope this helps.

Michael Glaesemann
grzm myrealbox com




pgsql-general by date:

Previous
From: "rlee0001"
Date:
Subject: Re: PostgreSQL Top 10 Wishlist
Next
From: "Jonel Rienton"
Date:
Subject: Re: Moving PostgreSQL data directory on Windows