Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
PostGre
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  12 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Roedy Green  
View profile  
 More options Jun 4 2012, 10:46 am
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Mon, 04 Jun 2012 07:46:28 -0700
Local: Mon, Jun 4 2012 10:46 am
Subject: PostGre
PostGre 9.1.4 was released today.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hans Castorp  
View profile  
 More options Jun 4 2012, 11:52 am
Newsgroups: comp.lang.java.databases
From: Hans Castorp <REWYRLXHE...@spammotel.com>
Date: Mon, 04 Jun 2012 17:52:25 +0200
Local: Mon, Jun 4 2012 11:52 am
Subject: Re: PostGre
Roedy Green wrote on 04.06.2012 16:46:

> PostGre 9.1.4 was released today.

The name is either written as Postgres or PostgreSQL, never PostGre.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roedy Green  
View profile  
 More options Jun 7 2012, 8:02 pm
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Thu, 07 Jun 2012 17:02:01 -0700
Local: Thurs, Jun 7 2012 8:02 pm
Subject: Re: PostGre
On Mon, 04 Jun 2012 17:52:25 +0200, Hans Castorp
<REWYRLXHE...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>The name is either written as Postgres or PostgreSQL, never PostGre

 I have added that warning to
http://mindprod.com/jgloss/postgresql.html
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hans Castorp  
View profile  
 More options Jun 8 2012, 3:48 am
Newsgroups: comp.lang.java.databases
From: Hans Castorp <REWYRLXHE...@spammotel.com>
Date: Fri, 08 Jun 2012 09:48:35 +0200
Local: Fri, Jun 8 2012 3:48 am
Subject: Re: PostGre

Roedy Green wrote on 08.06.2012 02:02:

> On Mon, 04 Jun 2012 17:52:25 +0200, Hans Castorp
> <REWYRLXHE...@spammotel.com> wrote, quoted or indirectly quoted
> someone who said :

>> The name is either written as Postgres or PostgreSQL, never PostGre
>   I have added that warning to
> http://mindprod.com/jgloss/postgresql.html

You got it wrong again

   "2012-06-04 It is also known as Postgre, but never Postgres."

No, it's not.

That should read:

   "2012-06-04 It is also known as Postgres, but never Postgre."


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Luuk  
View profile  
 More options Jun 8 2012, 2:13 pm
Newsgroups: comp.lang.java.databases
From: Luuk <l...@invalid.lan>
Date: Fri, 08 Jun 2012 20:13:46 +0200
Local: Fri, Jun 8 2012 2:13 pm
Subject: Re: PostGre
On 04-06-2012 16:46, Roedy Green wrote:

> PostGre 9.1.4 was released today.

I dont see why theese 2 point are "Advantages of MySQL over PostgreSQL":

1) MySQL support is more widespread on ISP (Internet Service Provider)
webservers.
Because its used more, it has an advantage? Whats the technical point in
this?

2) There more books and tutorials on MySQL
Everyone can write a book, but its about the good books that count!


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roedy Green  
View profile  
 More options Jun 8 2012, 6:16 pm
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Fri, 08 Jun 2012 15:16:43 -0700
Local: Fri, Jun 8 2012 6:16 pm
Subject: Re: PostGre
On Fri, 08 Jun 2012 20:13:46 +0200, Luuk <l...@invalid.lan> wrote,
quoted or indirectly quoted someone who said :

>I dont see why theese 2 point are "Advantages of MySQL over PostgreSQL":

>1) MySQL support is more widespread on ISP (Internet Service Provider)
>webservers.
>Because its used more, it has an advantage? Whats the technical point in
>this?

If you write an app, you may want to host it somewhere.  You have more
choices.  This means probably better service, lower price, faster
response etc .  Think of the opposite extreme, writing your code for
some obscure engine. Then you pretty well have to host it on your own
server.

>2) There more books and tutorials on MySQL
>Everyone can write a book, but its about the good books that count!

Granted.  The more books there are, the more competition, so the
better odds of finding a good one.  The most awful books are usually
on some obscure topic without any alternatives.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roedy Green  
View profile  
 More options Jun 8 2012, 6:17 pm
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Fri, 08 Jun 2012 15:17:04 -0700
Local: Fri, Jun 8 2012 6:17 pm
Subject: Re: PostGre
On Fri, 08 Jun 2012 09:48:35 +0200, Hans Castorp
<REWYRLXHE...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>   "2012-06-04 It is also known as Postgres, but never Postgre."

fixed. thanks for your patience.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Luuk  
View profile  
 More options Jun 9 2012, 5:14 am
Newsgroups: comp.lang.java.databases
From: Luuk <l...@invalid.lan>
Date: Sat, 09 Jun 2012 11:14:15 +0200
Local: Sat, Jun 9 2012 5:14 am
Subject: Re: PostGre
On 09-06-2012 00:17, Roedy Green wrote:

> On Fri, 08 Jun 2012 09:48:35 +0200, Hans Castorp
> <REWYRLXHE...@spammotel.com> wrote, quoted or indirectly quoted
> someone who said :

>>   "2012-06-04 It is also known as Postgres, but never Postgre."
> fixed. thanks for your patience.

"Postgre JDBC type 4 driver" ==> "PostgreSQL JDBC Driver"  ?

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Hans Castorp  
View profile  
 More options Jun 9 2012, 5:55 am
Newsgroups: comp.lang.java.databases
From: Hans Castorp <REWYRLXHE...@spammotel.com>
Date: Sat, 09 Jun 2012 11:55:58 +0200
Local: Sat, Jun 9 2012 5:55 am
Subject: Re: PostGre
Roedy Green wrote on 08.06.2012 02:02:

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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roedy Green  
View profile  
 More options Jun 11 2012, 2:15 pm
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Mon, 11 Jun 2012 11:15:58 -0700
Local: Mon, Jun 11 2012 2:15 pm
Subject: Re: PostGre
On Sat, 09 Jun 2012 11:14:15 +0200, Luuk <l...@invalid.lan> wrote,
quoted or indirectly quoted someone who said :

>"Postgre JDBC type 4 driver" ==> "PostgreSQL JDBC Driver"  ?

fixed thanks.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Roedy Green  
View profile  
 More options Jun 11 2012, 2:16 pm
Newsgroups: comp.lang.java.databases
From: Roedy Green <see_webs...@mindprod.com.invalid>
Date: Mon, 11 Jun 2012 11:16:31 -0700
Local: Mon, Jun 11 2012 2:16 pm
Subject: Re: PostGre
On Sat, 09 Jun 2012 11:55:58 +0200, Hans Castorp
<REWYRLXHE...@spammotel.com> wrote, quoted or indirectly quoted
someone who said :

>In the section "Advantages of PostgreSQL over MySQL", you might want to add the following items

added thanks.   Will be uploaded within the hour.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Controlling complexity is the essence of computer programming.
~ Brian W. Kernighan 1942-01-01
.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Lew  
View profile  
 More options Sep 26 2012, 7:20 pm
Newsgroups: comp.lang.java.databases
From: Lew <lewbl...@gmail.com>
Date: Wed, 26 Sep 2012 16:20:15 -0700 (PDT)
Local: Wed, Sep 26 2012 7:20 pm
Subject: Re: PostGre

 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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »