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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Inconsistent: Getting array from result set
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Inconsistent: Getting array from result set