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

From Shawn Garbett
Subject Cube/Rollup/ and Connect by prior
Date
Msg-id 20060113142746.19449.qmail@web54406.mail.yahoo.com
Whole thread Raw
Responses Re: Cube/Rollup/ and Connect by prior
List pgsql-general
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?

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? Our data has lot's and lot's of trees.

Shawn

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: sort character data in arbitrary order?
Next
From: "tschak"
Date:
Subject: Row Size and Indexing