Re: arrays and jdbc - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: arrays and jdbc
Date
Msg-id 1044117055.1280.62.camel@inspiron.cramers
Whole thread Raw
In response to arrays and jdbc  (Richard Welty <rwelty@averillpark.net>)
Responses Re: arrays and jdbc  (Richard Welty <rwelty@averillpark.net>)
List 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@averillpark.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@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Richard Welty
Date:
Subject: arrays and jdbc
Next
From: Richard Welty
Date:
Subject: Re: arrays and jdbc