Re: Inconsistent: Getting array from result set
От | robrez |
---|---|
Тема | Re: Inconsistent: Getting array from result set |
Дата | |
Msg-id | 1382706623879-5775916.post@n5.nabble.com обсуждение исходный текст |
Ответ на | Re: Inconsistent: Getting array from result set (robrez <resendez.java@gmail.com>) |
Список | 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.
В списке pgsql-jdbc по дате отправления: