Path: csiph.com!usenet.pasdenom.info!news.albasani.net!news2.arglkargh.de!news.karotte.org!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Hans Castorp Newsgroups: comp.lang.java.databases Subject: Re: PostGre Date: Sat, 09 Jun 2012 11:55:58 +0200 Lines: 14 Message-ID: References: <56g2t71b3fl5d9ovhf7ak8rjgtfsjpd4r1@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net rX3eAuK3/iCDQMsaXfD48AH892stzwdQIr1Ra+bqSI9DMLdGP+Z2g/Dyq6nqmrdzg= Cancel-Lock: sha1:bsa5WV3fzaZeE7M60N9+QLaGLtU= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: <56g2t71b3fl5d9ovhf7ak8rjgtfsjpd4r1@4ax.com> Xref: csiph.com comp.lang.java.databases:547 Roedy Green wrote on 08.06.2012 02:02: > http://mindprod.com/jgloss/postgresql.html In the section "Advantages of PostgreSQL over MySQL", you might want to add the following items + More standard compliant than MySQL + Supports windowing functions + Supports common table expressions (CTE) including writeable CTEs + Supports recursive queries + No limits on the usage of subselect in DML statements + Supports table functions (select * from my_function()) + Supports transactional DDL + Supports user defined aggregate functions + Supports partial indexes