On Mon, Apr 27, 2009 at 3:00 PM, Robert Pepersack
<RPepersack@mdinsurance.state.md.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