Re: PostgreSQL Object-Oriented Database?

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "Robert Pepersack" <RPepersack(at)mdinsurance(dot)state(dot)md(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Object-Oriented Database?
Date: 2009-04-27 14:35:23
Message-ID: 20090427103523.afb0ef6c.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Robert Pepersack" <RPepersack(at)mdinsurance(dot)state(dot)md(dot)us>:

> Hi,
>
> Thanks in advance for your help.
>
> I have a lot of experience with object-oriented programming and relational databases, but I'm new to PostgreSQL.
>
> 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.
>
> Can someone tell me if this guy is right?

PostgreSQL supports an array type for any base column type. It's not
always the _best_ way to do things, but (in my experience) it's sometimes
better to use an array column than to do an additional one-to-many table.

Whether or not it's good design is highly dependent on the nature of
the data.

In psql, do \d on the table, if the field type is postfixed with a
[], then it's an array datatype:
http://www.postgresql.org/docs/8.3/static/arrays.html

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2009-04-27 14:42:12 Re: PostgreSQL Object-Oriented Database?
Previous Message Grzegorz Jaśkiewicz 2009-04-27 14:26:31 Re: PostgreSQL Object-Oriented Database?