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
