Arrays Question? -Simon Moses - Mailing list pgsql-jdbc

From Simon Moses
Subject Arrays Question? -Simon Moses
Date
Msg-id 20040925102054.53482.qmail@web14921.mail.yahoo.com
Whole thread Raw
Responses Re: Arrays Question? -Simon Moses  (Kris Jurka <books@ejurka.com>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Newbie question
Next
From: Nathan Crause
Date:
Subject: PreparedStatement