Neat. Hadn’t considered using something like that for reporting.
From: otrs-boun...@otrs.org [mailto:otrs-boun...@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 <dbo...@sinenomine.net<mailto:dbo...@sinenomine.net>> wrote: I'll see your T&Cs and raise you window functions ?? window functions? Not sure I follow. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs