Re: PostgreSQL Object-Oriented Database?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(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:26:31
Message-ID: 2f4958ff0904270726p6f750018k3b209c716dceeb32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 27, 2009 at 3:00 PM, Robert Pepersack
<RPepersack(at)mdinsurance(dot)state(dot)md(dot)us> wrote:
> 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?

Where I am from, it is very wrong approach. But most importantly, is
what is the search key in his queries. If that text field is, and he
uses loads of "LIKE" statements, than yes - he obviously doesn't know
databases well enough to use them properly.

--
GJ

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-04-27 14:35:23 Re: PostgreSQL Object-Oriented Database?
Previous Message Robert Pepersack 2009-04-27 14:00:59 PostgreSQL Object-Oriented Database?