From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Richard Welty <rwelty(at)averillpark(dot)net> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: arrays and jdbc |
Date: | 2003-02-01 16:30:56 |
Message-ID: | 1044117055.1280.62.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Richard,
You need to use the java.sql.Array interface to get at array objects
Dave
On Fri, 2003-01-31 at 17:51, Richard Welty wrote:
> i'm about to start on something which will be accessing arrays through the
> pgjdbc2 driver.
>
> is there anything i should know, or should i just have at it? should i just
> step through a row in the result set in numeric order, or is there a way of
> representing a specific array values in the row, that is, could i do
> something like
>
> int pct = resultset.getInt("percentage[1]");
>
> to get element one of int4 array percentage?
>
> thanks,
> richard
> --
> Richard Welty rwelty(at)averillpark(dot)net
> Averill Park Networking 518-573-7592
> Unix, Linux, IP Network Engineering, Security
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Welty | 2003-02-01 17:45:47 | Re: arrays and jdbc |
Previous Message | Richard Welty | 2003-01-31 22:51:02 | arrays and jdbc |