pointer to feature comparisons, please

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: pointer to feature comparisons, please
Date: 2007-06-13 13:57:10
Message-ID: CA331BD4-1662-4E4B-AB8F-753F578DDC34@earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello List,

Short version: I want pointers to feature comparisons of Postgres vs
Oracle. Can the list help?

Long version:

I'm working with a student on a project for school. I'm trying to
teach "right" methods of thinking and doing things, such as making
the database/data model the authoritative source rather than adding
code to the application layer.

I originally had him code his project for Postgres, but for reasons
beyond our control we've had to move to Oracle. In designing the
schema we have need of a constraint that checks values in other
tables. The way that I currently know how to do this in Postgres is
with PLpgSQL functions. Then I add something like

CONSTRAINT away_team_is_playing CHECK ( NOT teamIsPlaying
( awayteamid, timeid ) )

to the table schema. No big deal, except that it seems Oracle can't
use anything other than a simple column constraint. He can't use any
custom functions like he could in Postgres, and we've yet to find a
solution to do what he needs.

I didn't immediately find anything last night on the postgresql.org
website, or a wider Google search.

So, motivation aside, what I'm wanting is a couple of pointers to
feature comparisons of Postgres vs Oracle. What else is going to
bite him while he works on this project? Would be handy to have this
reference since neither of us are really DB wizards. (Besides!
Isn't it good to tout what Postgres does better than it's
competition? :-) )

Thanks,

Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-13 14:00:39 Re: Plperl & create contstraint trigger
Previous Message Tom Lane 2007-06-13 13:55:32 Re: Use of PROFILE in Makefiles