| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Simon Moses <ks_moses(at)yahoo(dot)com> |
| Cc: | pgsql jdbc <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Arrays Question? -Simon Moses |
| Date: | 2004-09-25 19:36:31 |
| Message-ID: | Pine.BSO.4.56.0409251433130.15566@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-09-26 19:40:02 | Re: PreparedStatement |
| Previous Message | Kris Jurka | 2004-09-25 19:33:07 | Re: PreparedStatement |