Re: Arrays returned in a result set

From: Barry Lind <barry(at)xythos(dot)com>
To: David Hooker <dhooker(at)a4networks(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Arrays returned in a result set
Date: 2002-02-05 18:01:10
Message-ID: 3C601DE6.5000205@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Barry Lind
> Sent: Monday, February 04, 2002 12:57 PM
> To: David Hooker
> Cc: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Hooker 2002-02-05 22:58:33 Re: Arrays returned in a result set
Previous Message Barry Lind 2002-02-05 11:02:34 Re: Blob support...