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

Re: PostGre

Received	by 10.66.84.5 with SMTP id u5mr521690pay.11.1348701615659; Wed, 26 Sep 2012 16:20:15 -0700 (PDT)
Received	by 10.68.242.37 with SMTP id wn5mr879544pbc.4.1348701615641; Wed, 26 Sep 2012 16:20:15 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!kq19no461431pbb.0!news-out.google.com!a8ni23357354pbd.1!nntp.google.com!4no12779369pbn.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.lang.java.databases
Date	Wed, 26 Sep 2012 16:20:15 -0700 (PDT)
In-Reply-To	<a3gkt8F6orU1@mid.individual.net>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=69.28.149.29; posting-account=CP-lKQoAAAAGtB5diOuGlDQk0jIwmH0T
NNTP-Posting-Host	69.28.149.29
References	<ehips7p75g4nr509pdkeorpp3gdheie0pj@4ax.com> <a343tpFqsaU1@mid.individual.net> <56g2t71b3fl5d9ovhf7ak8rjgtfsjpd4r1@4ax.com> <a3gkt8F6orU1@mid.individual.net>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<263288cc-1f18-4ade-8dda-9f89e50b27cf@googlegroups.com> (permalink)
Subject	Re: PostGre
From	Lew <lewbloch@gmail.com>
Injection-Date	Wed, 26 Sep 2012 23:20:15 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.lang.java.databases:566

Show key headers only | 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