Re: [otrs] Database Conversion from MySQL to PostgreSQL

May I point out MariaDB https://mariadb.org/ while we're talking about MySQL? Just in case you want a different MySQL that isn't encumbered by Oracle, but is a drop-in replacement for MySQL. On Thu, Mar 28, 2013 at 4:02 PM, David Boyes wrote:

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 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