| From: | Vitaliy Avdeev <vavdeev(at)sistyma(dot)net> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Two versions of jdbc driver returns different results |
| Date: | 2013-05-13 13:24:20 |
| Message-ID: | CAMRvkgMxpb3EtM3+yckDGvnowpDmj4qLYTAwwEfa3jrW=ZpiSw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hello, I have such problem.
postgresql-9.1-901 jdbc driver and postgresql-9.2-1002 returns different
values for the same query.
The result of the postgresql-9.1-901 is the same as returns psql.
I am using PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
Here is the code
PreparedStatement prepareStatement = conn.prepareStatement("select
rejected From "
+ "
\"CountReport7\"(237505,1367776800000,1368986400000,'millennium','Europe/Kiev');
");
System.out.println(prepareStatement);
prepareStatement.execute();
ResultSet rs = prepareStatement.getResultSet();
while (rs.next()) {
System.out.println(rs.getLong(1));
}
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2013-05-14 01:36:28 | Re: Two versions of jdbc driver returns different results |
| Previous Message | Devrim GÜNDÜZ | 2013-05-01 18:50:05 | Re: 9.3 driver |