On Mon, 2009-04-27 at 20:37 +0200, marcin mank wrote:
> Is there any sane reason to use an array column, besides performance
> (the values can be read in less disk seeks than in a
> table-with-a-foreign-key scenario)?
Yes.
http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/
I don't actually talk about array columns in the above but it does
discuss all the ways (except) for an array to deal with that problem. As
I recall the major downside to an array is that you can add or delete an
element, you must update the whole array. Plus you need to use specific
array functions to work with the array versus just a nice join.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997