Neat. Hadn’t considered using something like that for reporting.
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Bogdan Iosif
Sent: Thursday, March 28, 2013 3:51 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Database Conversion from MySQL to PostgreSQL
http://en.wikipedia.org/wiki/Window_functions
Very useful for some queries used mostly with reports (e.g. when you need that Nth occurence in ticket_history)
On Thu, Mar 28, 2013 at 9:46 PM, David Boyes