In response to "Robert Pepersack" <RPepersack@xxxxxxxxxxxxxxxxxxxxxxx>: > 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
