Cube/Rollup/ and Connect by prior

From: Shawn Garbett <shawn_garbett(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cube/Rollup/ and Connect by prior
Date: 2006-01-13 14:27:46
Message-ID: 20060113142746.19449.qmail@web54406.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tschak 2006-01-13 14:48:28 Row Size and Indexing
Previous Message Mikael Carneholm 2006-01-13 14:15:06 Re: Plans for 8.2?