Re: PostgreSQL Object-Oriented Database? - Mailing list pgsql-general

From Christophe
Subject Re: PostgreSQL Object-Oriented Database?
Date
Msg-id C2710A16-DC09-4D38-B36B-ECA6EBA4CD7B@thebuild.com
Whole thread Raw
In response to PostgreSQL Object-Oriented Database?  ("Robert Pepersack" <RPepersack@mdinsurance.state.md.us>)
List pgsql-general
On Apr 27, 2009, at 7:00 AM, Robert Pepersack wrote:
> My agency has a contractor that created a PostgreSQL database that
> he calls "object-oriented".  I noticed that the contractor has more
> than one value in a column separated by commas.  In the relational
> world, this obviously violates first normal form.  When I asked
> about it, he said that it's because PostgreSQL is an "object-
> oriented database".  I'm very skeptical.

Without knowing the details of the design, it's hard to comment on the
design's strengths or weaknesses.  However, there is nothing about
PostgreSQL that requires any different design than one would use on
any relational database.

Arrays are, sometimes, a good solution for particular problems, and
PostgreSQL has very fluent array functionality, but nothing about
PostgreSQL requires their use versus more traditional relational
designs.

pgsql-general by date:

Previous
From: Kynn Jones
Date:
Subject: Which header and lib files to use when compiling libpq-code?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Which header and lib files to use when compiling libpq-code?