Re: Inconsistent: Getting array from result set

From: robrez <resendez(dot)java(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inconsistent: Getting array from result set
Date: 2013-10-25 13:10:23
Message-ID: 1382706623879-5775916.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

annddddd now that link doesn't work...

//BoilerPlate...

db.getConnection().setAutoCommit(false);

String TABLE = "CREATE TABLE array_test ( at_id integer, at_array
character varying[] )";
PreparedStatement createStmt =
db.getConnection().prepareStatement(TABLE);
createStmt.execute();
createStmt.close();

String INSERT = "INSERT INTO array_test (at_id, at_array) VALUES (?,
ARRAY[ 'A', 'B', 'C',

'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K' ])";
PreparedStatement insertStmt =
db.getConnection().prepareStatement(INSERT);
for (int i = 0; i < 100; i++) {
insertStmt.setInt(1, i);
insertStmt.execute();
}
insertStmt.close();

String SELECT = "SELECT at_id, at_array, at_array::character varying
as at_array_str FROM

array_test WHERE at_id = ?";
PreparedStatement selectStmt =
db.getConnection().prepareStatement(SELECT);
for (int i = 0; i < 100; i++) {
selectStmt.setInt(1, i);
ResultSet rs = selectStmt.executeQuery();
while (rs.next()) {
Integer id = rs.getInt("at_id");
Array arrayObj = rs.getArray("at_array");
String arrayStr = rs.getString("at_array_str");
if (arrayObj != null && arrayStr != null &&
arrayObj.toString() != null) {
if (arrayObj.toString().equals(arrayStr)) {
System.out.println("OKAY Id=" + id.toString() + " "
+ arrayObj.toString()

+ " == " + arrayStr);
} else {
System.out.println("BAD! Id=" + id.toString() + " "
+ arrayObj.toString()

+ " != " + arrayStr);
}
} else {
if (arrayObj != null) {
String[] asStringArray = (String[]) ((Array)
arrayObj).getArray();
if (asStringArray != null) {
List<String> asList =
Arrays.asList(asStringArray);
//WHY was arrayStr null? WHY is
arrayObj.toString() null?
System.out.println("BAD! Id=" + id.toString() +
" NULL != " +

asList.toString());
}
}
}

}
rs.close();
}
selectStmt.close();

//The following reads the same records, but only makes 1 result set
so everything 'works'
String SELECTALL = "SELECT at_id, at_array, at_array::character
varying as at_array_str

FROM array_test ORDER BY at_id";
PreparedStatement selectAllStmt =
db.getConnection().prepareStatement(SELECTALL);
ResultSet rs = selectAllStmt.executeQuery();
while (rs.next()) {
Integer id = rs.getInt("at_id");
Object arrayObj = rs.getObject("at_array");
String arrayStr = rs.getString("at_array_str");
if (arrayObj != null && arrayStr != null && arrayObj.toString()
!= null) {
if (arrayObj.toString().equals(arrayStr)) {
System.out.println("OKAY Id=" + id.toString() + " " +
arrayObj.toString() + "

== " + arrayStr);
} else {
System.out.println("BAD! Id=" + id.toString() + " " +
arrayObj.toString() + "

!= " + arrayStr);
}
} else {
if (arrayObj != null) {
String[] asStringArray = (String[]) ((Array)
arrayObj).getArray();
if (asStringArray != null) {
List<String> asList = Arrays.asList(asStringArray);
//WHY was arrayStr null? WHY is arrayObj.toString()
null?
System.out.println("BAD! Id=" + id.toString() + "
NULL != " +

asList.toString());
}
}
}

}
rs.close();
selectAllStmt.close();

PreparedStatement dropStmt =
db.getConnection().prepareStatement("DROP TABLE array_test");
dropStmt.execute();
dropStmt.close();

db.getConnection().setAutoCommit(true);

//output:

OKAY Id=0 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=1 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=2 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=3 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=4 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
BAD! Id=5 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=6 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=7 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=8 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=9 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=10 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=11 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=12 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=13 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=14 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=15 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=16 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=17 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=18 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=19 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=20 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=21 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=22 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=23 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=24 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=25 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=26 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=27 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=28 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=29 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=30 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=31 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=32 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=33 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=34 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=35 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=36 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=37 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=38 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=39 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=40 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=41 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=42 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=43 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=44 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=45 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=46 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=47 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=48 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=49 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=50 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=51 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=52 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=53 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=54 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=55 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=56 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=57 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=58 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=59 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=60 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=61 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=62 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=63 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=64 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=65 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=66 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=67 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=68 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=69 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=70 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=71 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=72 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=73 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=74 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=75 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=76 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=77 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=78 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=79 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=80 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=81 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=82 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=83 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=84 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=85 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=86 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=87 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=88 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=89 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=90 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=91 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=92 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=93 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=94 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=95 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=96 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=97 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=98 NULL != [A, B, C, D, E, F, G, H, I, J, K]
BAD! Id=99 NULL != [A, B, C, D, E, F, G, H, I, J, K]
OKAY Id=0 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=1 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=2 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=3 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=4 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=5 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=6 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=7 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=8 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=9 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=10 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=11 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=12 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=13 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=14 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=15 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=16 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=17 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=18 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=19 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=20 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=21 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=22 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=23 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=24 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=25 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=26 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=27 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=28 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=29 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=30 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=31 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=32 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=33 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=34 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=35 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=36 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=37 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=38 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=39 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=40 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=41 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=42 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=43 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=44 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=45 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=46 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=47 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=48 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=49 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=50 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=51 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=52 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=53 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=54 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=55 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=56 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=57 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=58 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=59 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=60 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=61 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=62 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=63 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=64 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=65 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=66 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=67 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=68 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=69 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=70 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=71 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=72 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=73 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=74 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=75 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=76 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=77 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=78 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=79 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=80 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=81 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=82 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=83 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=84 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=85 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=86 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=87 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=88 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=89 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=90 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=91 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=92 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=93 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=94 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=95 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=96 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=97 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=98 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}
OKAY Id=99 {A,B,C,D,E,F,G,H,I,J,K} == {A,B,C,D,E,F,G,H,I,J,K}

Sorry it isn't a real test using the test suite.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Inconsistent-Getting-array-from-result-set-tp5775841p5775916.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2013-10-28 03:29:10 Re: Inconsistent: Getting array from result set
Previous Message Dave Cramer 2013-10-25 13:10:02 Re: Inconsistent: Getting array from result set