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@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
