Re: [GENERAL] arrays

>>>>> "Josh" == Josh Berkus <josh@agliodbs.com> writes:
   Josh> Now, I know at least one person who is using arrays to store   Josh> scientific data.  However, that data
arrivesin his lab in   Josh> the form of matrices, and is not used for joins or query   Josh> criteria beyond a simple
"where"clause.
 

Indeed, my first attempt to use arrays was to maintain some basic
statistics about a set of data.  The array elements where to be
distribution moments and would only be used in "where" clauses.  The
problem was that I wanted to be about to update the statistics using
triggers whenever the main data was updated.  The inability to access
a specific array element in PL/pgSQL code made this so painful I ended
up just extending a table with more columns.

roland
--            PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375