Oracle analytic functions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Oracle analytic functions
Date
Msg-id 3F739929.7000007@familyhealth.com.au
Whole thread Raw
List 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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ctid matching behavior changed?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Question on adding new indexes to Postgresql