On Sat, 25 Sep 2004, Simon Moses wrote:
> i want to use arrays(like int4[]) in my tables insted
> of taking many int4 fields.
In general this isn't a great idea. You lose a lot of flexibility for no
real good reason. Combining these field just obscures what's going on and
makes it more difficult to work with them. The only possible reason I
could see for doing this is if you had an outrageous number of fields
(more than the postgresql limit), but that suggests a more drastic
redesign instead of just stuffing them into arrays.
What do you think the possible advantages are?
Kris Jurka