| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | Shawn Garbett <shawn_garbett(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Cube/Rollup/ and Connect by prior |
| Date: | 2006-01-14 22:45:33 |
| Message-ID: | F95F14D2-E6A0-4183-8AF8-29F51FAB5E0E@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonel Rienton | 2006-01-14 23:31:15 | Re: Moving PostgreSQL data directory on Windows |
| Previous Message | Michael Fuhr | 2006-01-14 20:10:07 | Re: sort character data in arbitrary order? |