| From: | Fernando Nasser <fnasser(at)redhat(dot)com> |
|---|---|
| To: | Chris Faulkner <chrisf(at)oramap(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: binding variable length array |
| Date: | 2003-08-28 14:01:35 |
| Message-ID: | 3F4E0B3F.1010507@redhat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Chris Faulkner wrote:
> Hello
>
> I have an variable length array in a table that I need to fetch into a Java
> structure via JDBC. What is the best way of doing this ? AT the moment, I am
> doing this
>
> select array[1], array[2], array[3], array[4] ..
>
> This only works because I know that whilst it varies in size, the array will
> never be larger than 4. But this is obviously not very nice.
>
Have you tried getArray(int) for 'SELECT array ...'?
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian W. Flotzinger | 2003-08-28 16:52:05 | unsubscribe |
| Previous Message | Tom Lane | 2003-08-28 13:34:45 | Re: pg 7.3 Time function not working |