Re: binding variable length array

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@xxxxxxxxxx
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend