Search Postgresql Archives

Re: PostgreSQL Object-Oriented Database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux