On Mon, Apr 27, 2009 at 3:00 PM, Robert Pepersack <RPepersack@xxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
