Re: Oracle and Postgresql

From: Artacus <artacus(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle and Postgresql
Date: 2008-09-03 04:09:26
Message-ID: 48BE0DF6.1010507@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

I can't speak from the dba perspective, but I mainly write applications
against Postgres and Oracle. I've used a dozen or more RDBMS's and
Postgres and Oracle are by far the most similar of any two.

When the two differ, its about an even split for when I say "I wish
Oracle did it like Postgres" and "I wish Postgres did it like Oracle."

Others have mentioned some areas where Postgres is lacking that will
soon be addressed such as CTE's. I'd really like to see Postgres
implement something like MERGE INTO, and stored procedures instead of
just functions.

On the other side of the coin, Oracle doesn't have a boolean type (in
SQL) which is annoying; you don't have to select from 'dual';
generate_series() is quite useful; and custom aggregates are easier in
postgres.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph S 2008-09-03 04:10:14 Re: Index non-usage problem in 8.2.9
Previous Message Tom Lane 2008-09-03 03:59:45 Re: Index non-usage problem in 8.2.9

Browse pgsql-www by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2008-09-03 08:23:12 Updated 8.3 PDF, added 8.4 PDF
Previous Message Ow Mun Heng 2008-09-03 03:06:25 Re: Oracle and Postgresql