Thread: Arrays returned in a result set

Arrays returned in a result set

From
"David Hooker"
Date:
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?

Re: Arrays returned in a result set

From
Barry Lind
Date:
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?
>



Re: Arrays returned in a result set

From
"David Hooker"
Date:
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



Re: Arrays returned in a result set

From
Barry Lind
Date:
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
>
>
>
>