Skip site navigation (1) Skip section navigation (2)

benefits of an Array Column?

From: jarednevans(at)yahoo(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: benefits of an Array Column?
Date: 2004-06-14 17:50:05
Message-ID: cakogd$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I was reading the o'reilly practical PostgreSQL book and came across
the chapter that mentioned the Array Column.

I fail to see the scenarios where this would be an useful feature.  How
is this better than linking to another table that could serve the same

For instance, the example used in the book metions the "favorite books
of employees" by using a column for employee name and array column of
favorite book titles for that employee.

I could also approach this by having an employee master table and book
titles master table then creating a third table between these two
tables that would have rows that matched up employees with their
favorite titles.



pgsql-novice by date

Next:From: Eduardo V. RodríguezDate: 2004-06-15 00:17:37
Subject: Primary Key
Previous:From: crystal clearDate: 2004-06-14 15:48:28
Subject: week format?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group