binding variable length array - Mailing list pgsql-jdbc

From Chris Faulkner
Subject binding variable length array
Date
Msg-id DGENKIKMJILAAKJGFHKFMENDCGAA.chrisf@oramap.com
Whole thread Raw
Responses Re: binding variable length array
List pgsql-jdbc
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.

Thanks

Chris




pgsql-jdbc by date:

Previous
From: Uday Walia
Date:
Subject: pg 7.3 Time function not working
Next
From: Toby Doig
Date:
Subject: Re: Help - lo_close: invalid large obj descriptor