Lists: | pgsql-jdbc |
---|
From: | Simon Moses <ks_moses(at)yahoo(dot)com> |
---|---|
To: | pgsql jdbc <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Arrays Question? -Simon Moses |
Date: | 2004-09-25 10:20:54 |
Message-ID: | 20040925102054.53482.qmail@web14921.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
dear sir,
i want to use arrays(like int4[]) in my tables insted
of taking many int4 fields.
----------
for ex.
Intvalues int4[2]
insted of
bill_no int4
qty int4
i can assume that int4[1] is bill_no and int4[2] is
qty.
i can change code to support '{1,2}' syntax.
----------
is there any performance problem?
is there any SQL syntax problem? like i cannot put
'order by' or 'group by' or where condition or .. ?
is there anyone using this without any problems?
in future will i get problems?
thanks in advance.
-Simon Moses
Bangalore.
India.
=====
**************************
Visit My Home Page
http://www.geocities.com/ks_moses
updated: 22 February 2004.
Simon Moses
**************************
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
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 |
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