Re: Arrays returned in a result set - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Arrays returned in a result set
Date
Msg-id 3C601DE6.5000205@xythos.com
Whole thread Raw
In response to Re: Arrays returned in a result set  ("David Hooker" <dhooker@a4networks.com>)
List pgsql-jdbc
David,

Sorry I wasn't more specific.   In 7.2 the postgres jdbc driver supports
the standard jdbc methods ResultSet.getArray() and
PreparedStatement.setArray().  I haven't used this functionality, but it
was added in 7.2.

thanks,
--Barry

David Hooker wrote:

> Ok, but what I really want to know is if there is *special* support for
> arrays.  As far as I can tell, arrays are just strings in the result
> set, with the "{value, ...}" formatting.  So do I have to write code to
> parse through the string, or does the drive provide me with some kind of
> convienence methods or objects?
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Barry Lind
> Sent: Monday, February 04, 2002 12:57 PM
> To: David Hooker
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] Arrays returned in a result set
>
>
> David,
>
> The 7.2 code should support arrays.
>
> --Barry
>
>
> David Hooker wrote:
>
>
>>Are array columns not handled specially when returned in a result set?
>>
>
>>Are there any convienence functions to parse/iterate through an array
>>
> in
>
>>a result set?
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>



pgsql-jdbc by date:

Previous
From: "David Hooker"
Date:
Subject: Re: Arrays returned in a result set
Next
From: "Peter V. Cooper"
Date:
Subject: Re: New to Postgresql - Backend timeout /JDBC