1) Table and row constructors
2) CUBE and ROLLUP functions
Of course OLAP merely means that you are doing data mining rather than transaction processing, so it is more of an approach than a set of supported technologies. PostgreSQL handles OLAP *much* better than MySQL which doesn't even support views....
If you can tell us more about what you need, maybe we can help.
Best Wishes, Chris Travers Metatron Technology Consulting
Jason Monserrate wrote:
I'm a student currently working on a postgresql based project. I want to know whether olap technologies are compatible with postgresql and would like some links to sites that could give me more info on this subject. What is the latest on olap in postgresql????
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
begin:vcard fn:Chris Travers n:Travers;Chris email;internet:[EMAIL PROTECTED] x-mozilla-html:FALSE version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]