Oracle analytic functions

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Oracle analytic functions
Date: 2003-09-26 01:40:57
Message-ID: 3F739929.7000007@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi guys,

I thought I'd pass this around as an interested reference page. Gives
us an idea of how far we need to go to compete with Oracle for data
analysis...

http://www.akadia.com/services/ora_analytic_functions.html

Interesting stuff:
* Accessing rows around your current row
* Lag, lead
* Top N queries
* Ranges
* etc.

Cheers,

Chris

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-09-26 01:51:57 Re: Question on adding new indexes to Postgresql
Previous Message Tom Lane 2003-09-26 01:18:11 Re: ctid matching behavior changed?