On Jan 27, 2006, at 4:41 , Eric E wrote:
I second that, and I'd love to have someone clarify the appropriate time to use arrays vs. more columns or an referenced tabled. I've always found that confusing.
I would only use arrays if the natural data type of the data is an array, such as some math applications. In these situations, for the most part you are not going to be doing a lot of operations on elements of the array, but rather the array value as a whole. While PostgreSQL does have array support, PostgreSQL is a relational database and as such is designed to handle relational data and is best at handling data that is stored relationally, i.e., in tables and columns.
Michael Glaesemann grzm myrealbox com
