>>>>> "m" == m hvostinski <makhvost@xxxxxxxxx> writes: m> I would appreciate if someone could clarify the aspects of using array m> columns. In general, bad idea. m> We need to store up to ten related integer values per row and currently it m> is implemented as a varchar column that holds a string that is concatenated m> by a trigger function. Something like this: Why? If you were storing these as a daughter table, then you get easy parsing, easy concurrent updating, easy access to aggregate functions. Just like SQL was meant to be used. Stop thinking of tables as Excel sheets. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <merlyn@xxxxxxxxxxxxxx> <URL:http://www.stonehenge.com/merlyn/> Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc. See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
