Groups > comp.lang.java.databases > #566

Re: PostGre

Newsgroups	comp.lang.java.databases
Date	2012-09-26 16:20 -0700
References	<ehips7p75g4nr509pdkeorpp3gdheie0pj@4ax.com> <a343tpFqsaU1@mid.individual.net> <56g2t71b3fl5d9ovhf7ak8rjgtfsjpd4r1@4ax.com> <a3gkt8F6orU1@mid.individual.net>
Message-ID	<263288cc-1f18-4ade-8dda-9f89e50b27cf@googlegroups.com> (permalink)
Subject	Re: PostGre
From	Lew <lewbloch@gmail.com>

Show all headers | View raw

 Hans Castorp wrote:
> Roedy Green wrote:
>> 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

In particular PG has a real TIMESTAMP type.

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

Supports relational integrity without having to beg it to.

See also
http://troels.arvin.dk/db/rdbms/

-- 
Lew

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-04 07:46 -0700
  Re: PostGre Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-06-04 17:52 +0200
    Re: PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-07 17:02 -0700
      Re: PostGre Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-06-08 09:48 +0200
        Re: PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-08 15:17 -0700
          Re: PostGre Luuk <luuk@invalid.lan> - 2012-06-09 11:14 +0200
            Re: PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-11 11:15 -0700
      Re: PostGre Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-06-09 11:55 +0200
        Re: PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-11 11:16 -0700
        Re: PostGre Lew <lewbloch@gmail.com> - 2012-09-26 16:20 -0700
  Re: PostGre Luuk <luuk@invalid.lan> - 2012-06-08 20:13 +0200
    Re: PostGre Roedy Green <see_website@mindprod.com.invalid> - 2012-06-08 15:16 -0700

csiph-web