>>>>> "m" == m hvostinski <makhvost(at)gmail(dot)com> writes:
m> I would appreciate if someone could clarify the aspects of using array
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:
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
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion
In response to
pgsql-general by date
|Next:||From: Pavel Stehule||Date: 2009-12-26 06:55:51|
|Subject: Re: Clarification regarding array columns usage?|
|Previous:||From: Craig Ringer||Date: 2009-12-26 02:29:16|
|Subject: Re: Out of space making backup|